I hope this problem belongs to this group!

I have several sheets of budget numbers that are linking
from one sheet to another. In linking several sheets by
pulling totals from one sheet to create other totals in
another sheet we seem to have lost the ability to sort
without changing the totals on the endpoint sheet. This
happens because we're linking to the source sheet using
the Sheet and Cell info and the sort places the totals in
different cells than the ones named in the second sheet.
Anyway to deal with this problem? Thanks. Koz