Odd question re: cell referencing

Originally Posted by bindak

Hi, any help that you could provide would be greatly appreciated! I would like to reference a cell on another worksheet - but would like to keep it pointed at THAT cell, regardless of where the information currently in that cell might move to. (I have tried all forms of referencing, $A$1, A1, $A1, and A$1.) It seems that all of them seem to stay with the contents of the cell rather than staying with the cell location. Thanks for your help!

=Offset(A1,2,3)

points to cell D3, and stays there.

---