here is my scenario:
I have a excel file which contains 650 sheets. the first sheet is called Index and has a reference to all other sheets in col a (649 rows follow)

all the other sheets are named by the date of the data,
Sheet[2].name ="032211'
Sheet[3].name='031811'
etc.



in col b I would like to get a total of the sheet f2:f64000 of the sheet name found in col a

like:

032211 123,345.00 (total from second sheet)
031811 432,564.88 (total from third sheet )

etc..


>
>

>=SUM(Sheet1:Sheet5!F:F)
>