I've got a workbook with multiple sheets in it. The first one is a huge file
(35 columns and 1,500 rows) with complex functions. Subsequent sheets are
linked to the first. To illustrate my question, I'm using a simplified
scenario:

-Sheet 1 is the "Master" that has sales data: Name, Month, State, Dollar Amt.
-Sheet 2 is linked to sheet 1 and picks up the CA sales data directly (ie: I
went into Sheet 2 and typed =sheet1!a1, etc. for all the CA sales data in
Sheet 1)
-Sheet 3 is also linked to sheet 1 and pickes up sales data from another state
-Sheet 4, ditto for another state.

My problem is that when I sort the data in Sheet 1, my links do not follow
my data, rather they continue to reference the linked cell. (If I have a
link in Sheet 2 to =Sheet1!A1, when sheet 1 is sorted, that reference stays
the same although the data is now in cell A10.) My linked references are not
absolute, so I'm not sure why the links are not following the data.

Hope someone can help! Thanks!

--
Susi