create new workbook invoice from template

Hi, I am new to the forum, and I am new to excel programming.
I have an invoice template, what i need it to do is copy the invoice details into a new workbook with the file name as Invoice, Number, Customer.
I would like the next invoice number to generate when a new invoice is created. I also want the Invoice total and tax amount to copy into an existing workbook with invoice number and customer name for record keeping. Not sure where to start, Thanks