Auto append/add new row (including formatting from previous row) when data is entered

Hello All,

Only my second post so once again sorry if its in the wrong place or not entirely the best description.

(EXCEL FOR MAC 2011)

I have attached my spreadsheet which I have recently formed in an attempt to make doing my accounts and VAT returns a considerable amount easier.

The spreadsheet consists of:
First row (A1:G1) - Named Column Headers
Second row - Blank
Third row (A3-G3) - Example data)
Fourth Row (AN EXAMPLE OF WHAT I WOULD LIKE TO SEE HAPPEN ONCE THE DATA HAS BEEN INPUT INTO THE ROW ABOVE)
Fifth Row - Totals Row(Containing auto sums of each column)

Note: Column B is a data validation drop down list taken from another sheet.

So I am trying to get excel to automatically add a new line below the last line but before the "Totals" row. If there is some kind of formula or code that I can use so that when ALL the data is completed into the current row an new line is auto appended beneath the current line which included its formatting and the drop down validation list.

Hope this makes sense and thanks in advance to anybody that helps with this issue.

Kind Regards
Stewart vat calculator EHF.xlsx

Sorry to bump this but does anyone have any ideas on how to solve this issue.