In Sheet 1, I've got all my raw data. Sheet 2 has the formulas that analyze this data. On a daily basis I need to insert new rows of raw data at the top of Sheet 1. However, Sheet 2 doesn't change since the formulas adjust themselves. If Row 2 in Sheet 2 initially was analyzing Row 2 in Sheet 1, inserting a row just above Row 2 in Sheet 1 causes Row 2 in Sheet 2 to adjust and therefore analyze Row 3 instead.

Of course this is how Excel is supposed to work. But how do I stop it from doing this? I want Row 2 in Sheet 2 to ALWAYS analyze Row 2 in Sheet 1, regardless of how many rows I insert above Row 2 in Sheet 1.

I also need Sheet 2 to expand its analysis to more rows as new rows of data are inserted at the top of Sheet 1. As an initial set up, I have 5 rows of raw data in Sheet 1. In Sheet 2, I have 5 rows analyzing their corresponding rows in Sheet 1. If I insert a row of data above Row 2 in Sheet 1, how do I make Sheet 2 automatically accommodate the extra row that was created by analyzing 6 rows (Rows 2-7) instead of the original 5? Here's a summary of all that I've said I want in a more visual form:

Before Row Insertion:

Sheet 1
RedBox
RedBird
BlueSock
YellowBird
BlueBox

Sheet 2 (before row insertion; periods divide columns)
Red.......Box
Red.......Bird
Blue......Sock
Yellow...Bird
Blue......Box

After Row Insertion:

Sheet 1
YellowSock
RedBox
RedBird
BlueSock
YellowBird
BlueBox

Sheet 2
Yellow...Sock
Red.......Box
Red.......Bird
Blue......Sock
Yellow...Bird
Blue......Box