Create invoices in Excel 2016 using Pivot Tables and VBA

We have an Excel Sheet with details of work to be invoiced each month. We have used Pivot Tables and VBA to create the Invoice. Additional VBA is required to do the following. 1. Add the header row of the pivot table to each page of the Invoice. 2. Increment the Invoice Number by 1 each time an invoice is printed. 3. Add the customer’s name & Address to the top of each Invoice 4. Repeat saving each Invoice as a PDF (named Company & Invoice No.) until all invoices have been generated and saved. 5. Save each invoice printed in one line on a new worksheet for keeping a record. The line will contain. Inv. No., Date, Company, net cost excluding VAT & Total Cost, Incl VAT. 6. Some additional formatting may be required to ensure that the invoice looks professional The sample Invoice is uploaded and the new VBA can be added to it if you wish.