Incrementing Rows in a Macro

Hi all,

I have written a very simple macro for the attached worksheet to add a new row and copy the formatting from the row below and then clear it ready for data entry.

As you can see, there will be options for new Plans, Pros and Data but I can't write the macro in the same way as it is using specific rows and any new Notices force the rest of the worksheet down by one.

Is there a way to tell these macros to look for the correct row and then insert, copy and clear?

Thanks a lot.