Hi!

Assume you enter the value in cell A1:

=IF(A1="","",INDIRECT("WS"&A1&"!$A$2"))

Biff

-----Original Message-----
Is there a way in excel that you can enter a value and it
will access the
approporiate worksheet. For example, I have worksheets
labelled WS1, WS2 and
WS3. If I enter a value of "1", I want it to pull the
value from cell A2 of
WS1, if I enter "2" it will pull the value of cell A2
from WS2 and so on...

.