Referencing A Sheet Name in a Formula

[cjnren]

Hi,
In column A I have a list of all the tab names (numbered 1-90).
In column B I want to get the value of a constant cell from each worksheet (cell $I$47 in each tab).

Is there a way I can use the tab name in column A as part of a formula to return the result, so that I can enter it once in cell B2 then autofill it down, so that on the rows below it would use the next tab name?

Col A Col B
1 I want it to return cell $I$47 on tab "1"
2 I want it to return cell $I$47 on tab "2"
3 Can this be done in a formula that can be autofilled down?

This would save me a lot of time.

Many thanks,

Chris

 

[Richard Schollar]

Hi

Try:

=INDIRECT(A1 & "!I47")

copied down

 

[cjnren]

Genius!

Thanks very much