hello.
i can`t figure out how to make what i call a "data conveyor"

lets say i have a set of formulas that analyaze data in columns A and B.
formulas are located in C2000 to F2050 with references at A2000 to B2050

is there any way to "push" the data down in the formula reference area one row at the time. As i need to analyze historical data one day(row) at the time.

Deleting a row below the reference does not work.. excel keeps changin the reference points.