Excel 2007 : "dynamic" referencing

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.