Excel: Use value of cell as part of a reference to another worksheet

[rifter1]

If I want a cell to equal the value of a cell on another sheet I use this terminology:

='Sheet3'!B1

But. Let's say the word "Sheet3" is the value of a cell, which I can change.

So in Cell A1 on Sheet 1, I can type "Sheet 3" or "Sheet 2" or whatever I want.

I want cell B2 on Sheet 1 to grab its value from Cell B1 on an unknown sheet (name taken from cell A1).

Is there a way to do this?

 

[SkipVought]

Hi,

Take a look at INDIRECT Function
[tt]
=INDIRECT(A1&"!B1")
[/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[rifter1]

oooooooooooooooo!
THANK you!