Inserting and Deleting Rows & 3-D Summing

Hi Guys

Could someone please assist me with two things, which I think will be simple for most, but not for me - Im fairly new at the VBA game but learning fast!

Firstly. Im trying to record a macro that will add or delete rows in a spreadsheet. I have attached a sample spreadsheet. I would like to add/delete one row at a time at the bottom of the table before the total row. I have tried the recording macro method which is fairly straight forward. However, there is one provision when it comes to deleting - I must be able to delete all rows except for the top row (which I have highlighted in blue). This row will have formulas and if it is deleted, there will no longer be anything to copy when I do the add row macro. How do you prevent the delete row macro from deleting the top row?

Secondly, Im trying to create a macro which will replicate the existing worksheet, but it must create the sheet in between the START and END sheets. Im using 3-D to sum and if I accidently create the sheet outside of those two, it wont 3-D sum. I also want the new sheet to automatically be called NEW PROPERTY each time I create it. I will rename the sheet immediately afterwards, but when I create it, it must have this name.

I would appreciate it if someone could help

here are all required codes:
Add row

Please Login or Register  to view this content.

Delete row (starting from the end of the list)

Please Login or Register  to view this content.

New sheet named "NEW PROPERTY"

Please Login or Register  to view this content.