Formula inside a Reference

[Blb8547]

I am trying to reference a cell in another sheet to auto update a form. EX. =sheet1!A2 but I would like to be able to change the 2 using another cell because I have multiple forumlas setup like =sheet1!B2 and so on. I want to change tge "2" so that wen I enter the next line in sheet 1 sheet 2 will auto update. Any ideas? I have tried =sheet1!indirect("B"&sheet2!A1) but that does not work at all.

 

[VoG]

Try like this

=INDIRECT(""Sheet1'!B"&A1)