sorting source data linked to another sheet
 

I have a multi column, multi row spreadsheet in which cells in one column of
data are individually linked to cells in another spreadsheet in same
workbook. When I sort the source data by a column other than the linked
column, the links do not follow the cells as they move to new locations in
the column.