How about something like:

=INDIRECT("Sheet5!D5")

HTH

"Hysteresis" wrote:

I am trying to lock a cell reference from one sheet to another.
i.e.
Cell A1 on "sheet 1" needs to ALWAYS be referenced by cell D5 on "sheet
2."

I have tried using $ signs and using the sheet protection to no avail.
What happens is when ever a user moves the information via drag and drop or
copy and paste (other than copying and pasting up in the tool bar) the cell
reference moves with it.
i.e.
User highlights the cell B1 on "sheet 1" and drags it to cell A1.

On my machine what happens is that Cell D5 is now referencing B1 and the
cell that was referencing B1 now indicates #REF.

Anyone know how to keep a point of reference regardless of the method used
to copy info?