Summary worksheet referencing multiple worksheets

[Guest]

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.

 

[Max]

In Sheet1