Thanks for the response shg.

To give you a quick overview of what I'm doing: I have a number of worksheets (continually growing, hence the problem!) that display a specific project with a number of dates and information. I then have an Overview page that shows all the projects on one page. Each worksheet's name is the project name - e.g. 30033_070. On the overview tab, I am using the INDIRECT function to look at the project number (in column A), and then pull through the information with the aforementioned formula.

Hence:

=INDIRECT(A93&"!B4"))

...would translate as:

=30033_70!B4

Hope that makes things a little clearere.

SamuelT