Say I have a sheet with 5 rows (1:5) and 5 columns (A:E) where I'll be inputting data. Is there some way to, when I insert data in cell D5, to have Excel automatically insert a new row at A6?

Think of a sheet that has multiple (horizontal) sections where I'm keeping track of some data. When I exceed a certain number of rows in any particular section, I want a new one inserted in that section.

At the same time, if I happen to remove enough data to where the one before last row ends up being empty, I want the last one removed.