cells lose relativity to other WorkSheets after data sort?

[Ed Murray - ALPCO]

two worksheets in same workbook. Cells in one WS use formula to pull data
from 2nd WS. If 2nd WS data is sorted, the first WS loses relativity and the
data changes.

 

[Frank Kabel]

Hi
if the source is sorted the cell references do nOT move with the former
entry but still remain linked to the cell position. No way to change
this. If you have a unique ID in your source table you may consider
using vLOOKUP for this:
http://www.contextures.com/xlFunctions02.html