Calculating using data from another worksheet

[Sid N]

Hello,

Is there a way wherein i can use a variable name, whose value is a
worksheet name, in a calculation? I do not want to hard-code the name of the
worksheet into the formula. I want to pick up the name from the value of a
cell.

Thanks
Sid N

 

[Frank Kabel]

Hi
if A1 contains the worksheet name try:
=INDIRECT("'" & A1 & "'!X1")
to return cell X1 from this sheet