Problems using sort when data has links to other sheets

[RobertD]

I have this problem when I do a sort. The sorted data has other sheets
linked to it. When I sort the data, the other sheets seemed locked to the
cell rather than the data.

For example, if sheet1 contains cell A1 with the formula ='sheet2'!B2 and I
do a sort of sheet2, what shows up in A1 is not the original data that was in
sheet2, B2. What shows up is the new data in sheet2, B2.

I tried putting =sheet2!$B$2 in the A1 cell in sheet1, but it doesn't make
any difference, I get exactly the same result.

However, if I cut and paste cell B2 in sheet2, then sheet1 A1 follows
sheet2B2 anywhere I put it.

How can I keep cell A1 pointing to the data in B2 through a sort?

Thanks,

RobertD