I have a list of sheet names in Col A of INDEX, each of which is preceded with a ',
there are 37 unique IDs
I want a SUM of cells AN2:AN600 from each of the sheets as
=SUM('NC (119 of 510)'!$AN$2:$AN$600)
I can create these manual
I'm trying to concoct a formula that will combine the sheet...