HELP - Referencing cells from different sheets using fixed increment

See the attached which contains a typical database based on your invoices.

You could either manually add each row, but given that there are repeats of information like the date, invoice no, etc, a smarter way to do it would be to use a front end menu, which would simply be a blank template of your current invoice.

When creating a new set of records for the database a macro would first clear the invoice template, then after entering details much as you do now, you would click a button and the details from the template would be copied to the database, and the repeated items copied to as many rows as necessary.

The template could also be used to suck data out of the database when you want to recreate an invoice. And of course a pivot table based on the data will allow you to dice and slice the data and allow you to analyse statistics for management reporting should that be required.