This helped and again openup a range of needed simplifications for me..
However when using the suggested =INDIRECT($A$1 & "!G3") the file refered
to should be open or else I get the #ref curse...

If there are a way around this it would help me quite a lot!

Regards
Gerrit



"Ron de Bruin" wrote:

Hi

See the help for the indirect function
with a sheet name in A1

=INDIRECT($A$1 & "!G3")




--
Regards Ron de Bruin
http://www.rondebruin.nl


"jnix" wrote in message ...
I have a spreadsheet which links to cells in several other worksheets. Is
there a way I can select which worksheet to link to based on information in a
different cell? For instance, I want cell c5 in worksheet A to link to cell
ab4 in the worksheet identified in cell c1 in worksheet A.

Thanks,

jnix