How to reference a worksheet which name is specified in a cell

[pimar]

Hi all,
I'm trying to reference a worksheet which name is specified in a cell.
Example:

assuming that cells A1 and A2 contain the name of my sheets :

A1 Sheet A
A2 Sheet B

in cell C1 I need to get a value from "Sheet A", like ='Sheet A"!X1,
while in C2 I'd like to have ='Sheet B'!X1
but I'd like to get bthe name of sheets from cell A1 and A2,

something like

C1 ='$A$1'!X1
C2 ='$A$2'!X1

Which is the right sintax?

Thanks in advance
*pimar

 

[Walt]

Hi pimar,

I think this is what you want:

A
1 Sheet A
2 Sheet B
3 =INDIRECT("'"&A1&"'"&"!X1")
4 =INDIRECT("'"&A2&"'"&"!X1")

The apostrophes within the double quotes allow for sheet names with
spaces.
No visual basic programming required.

Best Regards,
Walt Weber