This formula I created worked in Excel:
This formula is in my main sheet, 'Summary'.
I populated a list of sheet names in a work book and put it in column N in 'Summary'. If the names in my main sheet
A6:A100 match those in the other sheets then SUM all the numbers in column
C6:C1000 for each sheet (based on the sheetname).
For some reason it is only taking the number from the first sheet on my list of sheet names.
Could anyone help with this please?