You can use
=SheetB!$A$1

If rows/columns are inserted or deleted on sheet B (or if cells are moved),
that formula will change accordingly. If you don't want it to ever change,
try
=INDIRECT("SheetB!A1")

Sorting shouldn't change the cell at which the link is pointing with either
of these.



"barrowhill" wrote in message
...
I wish to link a cell in one worksheet (A) to pick up the contents of
another
cell in a different worksheet (B). This needs to be a fixed link in that
wherever the cell "appears" in worksheet B (worksheet B gets sorted). the
link is always pointing to it.

I hope this is understandable ???

Thanks in anticipation

Tom