To automatically create a variable number of worksheets, name them and the enter the

[SamT]

Create an invoice Template with the table and formulas.

For each Invoice Name, copy the Template and rename it, then fill in the blanks