I'm designing a Workbook for two different departments at work. In this workbook are two worksheets for the two different departments. Lets call them Worksheet A and Worksheet B.

I normally fill in the information on Worksheet A, and then Worksheet B is pulling some of that information, or referencing several cells on Worksheet A.

But sometimes, I need to sort Worksheet A (be it, alphabetically, or numerically), and I'd like to be able to do that, without the information on Worksheet B sorting as well. It seems like every formula I try, Worksheet B gets messed up because it follows whatever sorting I did on worksheet A.

The problem with this is also that a lot of the references are customer names or things that are unique to customers. So, I can't anticipate what data will be filling those fields before hand and put them in a cell reference formula. Is there a way of referencing a cell on Worksheet A, no matter where it moves to? I've tried using Absolute references in every different way and none of that seems to fix the problem.

Thanks!