I have a complete set of UNsorted, source data. I have created a SUBSET of
this data by LINKING and copying the desired ROWS.

My question: When I SORT the source set/rows of complete data (by name in
column A), the links in the subset remain linked to the CELL references in
column A, not the data. Therefore, the original copied data gets replaced
with the new sorted data. I have tried the links with and without absolute
cell references. I do not want to use "Paste Values" because the source data
may change and I want the copied subset to update automatically.

Is there a way to keep the LINKS to the original client rows of data in my
subset, while also being able to SORT the Source data?

***********
EXAMPLE
***********
Complete Source (Before sort)
--------
1 XYZ xxx
2 GHI xxx
3 LMN xxx
4 ABC xxx
5 RST xxx

Linked subset data (Before sort)
--------
1 RST xxx (cell formulas: =A5 or =$A5)
2 ABC xxx (cell formulas: =A4 or =$A$4)
3 GHI xxx (cell formulas: =A2 or =$A$2)


***********
***********
Complete Source (After sort)
--------
1 ABC xxx (previously 4)
2 GHI xxx (previously 2)
3 LMN xxx (previously 3)
4 RST xxx (previously 5)
5 XYZ xxx (previously 1)

Linked subset data (After sort)
--------
1 XYZ xxx (new =A5, wanted "RST" (original #5))
2 RST xxx (new =A4, wanted "ABC" (original #4))
3 GHI xxx (new =A2, wanted "GHI" (original #2))