I have a worksheet with numbers 1 through 53 in cells A6 thru A58,
respectively.

In cell E6 is the following formula that works and updates without having to
open the reference file:

=INDEX('[01-1209.xls]SFN 119'!$A$13:$C$35,E$64,2)

Note: the first two numbers in the formula is the number in A6 written as 01
instead of 1.

I want to copy this formula down to row E58; the formual for
E7 should be:

=INDEX('[02-1209.xls]SFN 119'!$A$13:$C$35,E$64,2)

E8 should be:

=INDEX('[03-1209.xls]SFN 119'!$A$13:$C$35,E$64,2)

etc.

How can I rewrite the formula in E6 so it can be successfully copied down
without having to open all 53 files?
(I have gotten it to work using the Indirect function €¦ but the Indirect
function worked ONLY if I have the referenced file open; and I dont have
enough memory to open all 53 files at once.)

Your help is appreciated. Thanks.