Linked Cells and Sort Function

[Barbara]

I have set up a worksheet with project names/numbers
(column for each). On the next worksheet, I pasted this
information as linked data and added additional columns
for descriptions. When sorting the first worksheet, the
linked columns sort appropriately, but the column with the
descriptions does not sort. Therefore, the descriptions
are not aligned with the correct project name/number.

Help - I have done this type of set up in past and did not
have this problem.

Thank you