excel help - another one request

[alrodopial]

This will be the last for a while (i hope)

In cell A1 i get from a formula the name of another sheet.Lets say i get "W1" (without quotes) which is the name of first sheet in my workbook.
I want to use this text in another formula that will use it as the name of the first sheet.
So the below formula:

=INDEX(A1,1,1) & B2

will be equal to : = 'W1'!B2

that will give me the contents of cell B2 of sheet W1

using text as a name of a sheet (or as a part of the name of a sheet combined with another text) and using this text in a formula

I know i saw somewhere something similar but my memory ...

Any ideas guys?

[alrodopial]

Found it.
It's the INDIRECT formula that I need to use.