In cell A1 on sheet 1 is where my data is

thus I want the outcome to be ='Sheet 1'!A1

However what I NEED is the numercal cell value to change based upon the input of another cell.

So if cell B1 on sheet 2 is 1

I need a formula like ='Sheet 1'!A(B2)

but that doesn't work?

Any help would be much apprcieted my boss is breathing down my neck waiting for this