Linked cells will continue to refer to the original cell, if the source
data is sorted. For example, if the following names are on Sheet1:

Joe
Sam
Fred

And on Sheet2 you have links:

=Sheet1!A1
=Sheet1!A2
=Sheet1!A3

If you sort the dates on Sheet1, the links on Sheet2 won't follow the
dates to their new location in the list. So, Sheet2!A1 would be linked
to Fred, instead of Joe.

If you had manually entered other data on Sheet2, it would now be
associated with the wrong name.


Destiny wrote:
I'm looking for a way to have linked cells in multiple worksheets (1
workbook) stay linked when sorting? Any suggestions?

Thank you,


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html