C

#### Chas

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