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