Excel 2010 Formula - adding in a new row and experiencing formatting issues

Unfortunately, the auto increment feature does not work in this instance, so you need to implement it within the formula itself, probably something like this:

Formula:

=INDEX(Sheetname!$B$2:$B$228,ROWS($2:$228)-ROWS($2:2)+1)+INDEX(Sheetname!$D$2:$D$228,ROWS($2:$228)-ROWS($2:2)+1)

(not tested, but the theory is correct)

Hope this helps

EDIT -
And I am glad I could point you in the right way about the Title rules as well