I have broken up a spreadsheet into several sections. In
each section, I would like to enter code that would allow
the user, once to the last row of each section, to
automatically insert another row(s). I have attempted to
write the code (see below) for this, but there is one
problem. Once one row is entered, the new row that is
created does not allow for another row to be created, i.e.
if the code is referenced to row 3 and a new row is
inserted (row 4), once the user hits enter in row 4, a new
row cannot be created.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 3 Then
Rows(Target.Row + 1).EntireRow.Insert
End If
End Sub