A cell in Worksheet 1 contains (by reference) the content of a particular
cell in Worksheet 2. If the cell-ID for the referenced content changes (say
due to a sort) how do I maintain the link to the content?

If 1CellE32 = 2CellX75 before the sort
And the sort moves 2CellX75 to 2CellX25
Then I want 1CellE32 = 2CellX25 after the sort

Can you help please?