Formula Question

[troxelone]

Probably an easy question, but I can't figure it out.

Is it possible to refer to different worksheets in a formula by a
cell. Here is an example to help clarify:

I want to refer to something on sheet2, which is usually ='sheet2'B2.
Is there a way to refer to this if I am working on sheet1 and list
a1=sheet2 then type ='a1"B2?

I have a ton of formulas that I don't want to change each time. It
would be so much easier if I can reference the sheets with a cell.

Thanks!
Theron

 

[T. Valko]

Try this:

A1 = sheet2

=INDIRECT("'"&A1&"'!B2")