Changing what cell is used in a formula with another cell

[Excel_dan]

I have 2 sheets, Sheet1 and Sheet2
On Sheet2 I have an equation that shows a value from Sheet1 with the following equation:
=Sheet1!A4
What I want to do is be able to change what column this formula pulls by changing cell B4 on Sheet2
I tried:
=Sheet1! & INDIRECT(B4) & 4 (where B4 contained the value C)
and several variations of the same thing, but I was not able to get the equation to work. I think this is just a syntax thing. Any help would be appreciated.

-Dan

 

[Tetra201]

Try

=INDIRECT("Sheet1!"&B4&4)

 

[Excel_dan]

Looks like that will work, thank you.