I welcome any suggestions. I have two worksheets in the same workbook.
Called:
1. "Parts Price"
2. "Catalogue"

One column in "Catalogue" directly reflects the value in a column in the
"Parts Price" worksheet. Currently I have simply used the formula eg
"='Parts Price'!G239" and so on for several hundred entries.

However I need to sort the rows in "Parts Price". The above works ok if I
cut and paste rows. However I do really need to utilise data sort of rows in
"Parts Price". However when I do that, the cell reference in "Catalogue"
remains with G239 rather than go to the new location in "Parts Price".

How can I do a data sort so that the link in "Catalogue" moves with the
information in "Parts Price"? I hope that this is kind of clear. Many
thanks for any assistance.
Jackie