Excel 2007 : "dynamic" referencing

[Krisztian]

Hi,
My problem is the following:
I am using filters to change the order of my data on a number of worksheets. Many cells refer to another cell on the previous worksheet. Eg: the February sheet cell A1 refers to January A1. The problem is that when I change the order (using filters) on sheet January, I want the references on sheet February to "move" with the cells on sheet January. I have rows on sheet January that do not (and should not) appear on sheet February. However, when I change the order or filter my data on sheet January it messes up my data on sheet February.
Any idea?
Thanks.

[GWilliams]

are you using absolute($A$1) or dynamic(A1) references? Excel should automatically change a dynamic reference for you.

Example:

place a value in cell A1
place the formula "=A1" in Cell B1
If you cut cell A1 and paste to cell A4
the formula in B1 will change to "=A4"

having a $ in front of the column or row portion of the reference makes it absolute. Like wise if you were to copy cell B1 to C1 it would change the formula to "=B1".