Cap an invoice with a footer after a variable number of records

I have created a macro to populate an invoice with data. The number of rows of data is variable. I need to cap the bottom of the invoice with a footer that contains a formula for column totals and the final price. Attached is the sample invoice.
I need help with the code to create X number of rows containing formulas to perform on the inputted data, and to cut bottom portion footer of the invoice from the side of the sheet and paste it after the last record from within the invoice, maintaining that the number of records within the invoice will be variable. Alternatively I might not need to cut and paste the footer but just have the macro generate it at the bottom.
Both the individual rows within the invoice contain SUM formulas as well as the footer rows. Cell formatting is important too as some cells are currency, dates, and numerics, and some have borders.
Any help with this would be greatly appreciated!!