If you have a nice key column with unique entries in both worksheets, maybe you
could replace your formulas with either =vlookup() or =index(match()).

Debra Dalgleish has some nice instructions at:
http://www.contextures.com/xlFunctions02.html

Destiny wrote:

We have linked cells in multiple worksheets (one workbook) that do not like
it when we sort. Is there a suggestion about how to have linked cells lock
even when sorting the data?

--

Dave Peterson