Alternative To INDIRECT?

Hi all,

A while ago, I posted up a thread regarding a formula that could pull through data by referencing a sheet name in a cell - and you good people solved the problem by recommending I use the INDIRECT function.

Initially the document was pretty small and only had a few instances on the INDIRECT. However, over the weeks the document has grown and it is now running very slowly. Can anyone suggest an alternative to the INDIRECT function as a number of people in the office have very slow machines and the documents is becoming more of a hinderance than a help.

Having done some research I've found out that INDIRECT is 'volative' as it continually calculates every cell and hence the slow down in speed.

The formula is basically:

Code:

INDIRECT(A93&"!B4"))

...although I am running a few IF(ISERROR type precursors to keep everything looking clean.

The long and short - can anyone suggest an alternative formula that isn't so volatile?

TIA,

SamuelT

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