Excel 2010 - Absolute References do Not Apply to Inserted Rows?

I'm trying to help a coworker build a spreadsheet that reads information off of a Master sheet onto 4 other sheets. The hope is that by making changes ONLY to the Master sheet that the other 4 will update automatically.

And then we ran into the trouble of not being able to insert new lines onto the Master sheet without throwing everything off on the other sheets.

(I've attached an example.)

For instance, if I go to the Master sheet in the Test.xlsx attachment, I've left out Lima from the alphabet. So, I insert a new row onto the Master, switch back to the Formula sheet where it should (theoretically) just update the cells to display the new data.

Not so. The Formula sheet just skips the new A13 and keeps on going.

I've looked for other solutions, and the primary one seems to be using Offset. Well, the coworker will be adding and deleting many, many rows over the course of the year, as it is a product log and we change our products often.

Thank you for taking the time to read and help,
KSherer

It works! I'm not even sure I know why, but thank you!