cell references

[starchildren3317]

I'm a bit unsure of what kind of reference I should use or if this is even possible but here is my problem:

I have a value in a particular cell, say cell b4 of sheet1.

I want cell A2 of sheet2 to always equal the value of what is in b4 of sheet1 regardless of if any new rows or columns are entered in sheet1 that would change the position of the values in that cell.

So in other words, say I have the word Hello in cell b4 of sheet1. A2 of sheet2 equals that cell so it has the value of Hello. Now in sheet1 I enter a new row and a new column so now Hello in sheet1 is in cell c5. Is there a way to keep the reference even after the change so that A2 of sheet2 is still referencing the cell with the value of Hello, now in c5?

thanks

 

[MrKowz]

Excel should do this by default.

 

[njimack]

The cell reference will update as you insert rows and columns
=Sheet1!B4