Using sheetname variable in a formula

M

mms

Hello.

Suppose a cell (say A1) contains the name of a valid worksheet (sa
Sheet1, Sheet2, and Sheet3).

I would like to use the *contents* of cell A1 in my formula to get a
data on that sheet.

Something like:

=*SheetNameStoredInCellA1*!A23

I know *=Sheet2!A23* is valid

but when I try =A1!A23, that does not work

Hope someone can help
 
Top