='Sheet B'!A1

will pick up cell A1, and will change as Sheet B is sorted.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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