I need help if it is possible. I have 4 workbooks that each contain 36
sheets named 01,02, thru 36. Each sheet is identical layout, just
unique data. Each book is named by year, 2003,2004,2005,2006. I have a
report page that I use to lookup data that I need to change once a
week. The lookup data could be on any of the sheets within anyone of
the books. I am using the following to find the information I need in
one of the cells.

=IF(ISERROR(VLOOKUP($B$4,'[2005.xls]33'!$D$7:$K$49,5,FALSE)),"0",VLOOKUP($B$4,'[2005.xls]33'!$D$7:$K$49,5,FALSE))

There are about 30 different occurrences like the above only the sheet
changes every week. Is there a way that I can replace the
'[2005.xls]33' in the above formula to look at another sheet / cell,
where all I have to do is change one cell each time. That way each week
I only need to change 6 cells. If I can get this to work I can refine
what I am looking for based on other sheets, I just don't want to
change all the formulas each week.

Thanks in advance and if I need to clarify what I am doing please let
me know.

Chas