Scenario: multiple worksheets (sheet1,sheet2,sheet3,etc) sheet 1 is a
summary. Sheet2!A1 contains the number 22, Sheet3!A1 contains the number 33

Based on the value in Sheet1!A1 I want to return a value in Sheet1!A2 based
on the data in the remaining sheets. In Sheet1!A1 I want to enter "Sheet2"
and then in Sheet1!A2 I want the value 22 returned from Sheet2!A1. Similarly
if I enter in Sheet1!A1 "Sheet3" and then in Sheet1!A2 the value 33 should be
returned which comes from Sheet3!A3.

In Sheet1
-------------
With the sheetname input into cell A1
(as per post)

Try in A2: =INDIRECT("'"&A1&"'!A1")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Jon" wrote in message
...
Scenario: multiple worksheets (sheet1,sheet2,sheet3,etc) sheet 1 is a
summary. Sheet2!A1 contains the number 22, Sheet3!A1 contains the number
33

Based on the value in Sheet1!A1 I want to return a value in Sheet1!A2
based
on the data in the remaining sheets. In Sheet1!A1 I want to enter "Sheet2"
and then in Sheet1!A2 I want the value 22 returned from Sheet2!A1.
Similarly
if I enter in Sheet1!A1 "Sheet3" and then in Sheet1!A2 the value 33 should
be
returned which comes from Sheet3!A3.