I have a workbook that I’m developing that helps me calculate revenue for my business (Trucking)

It has multiple tables for things like revenue, expenses, fixed costs, etc.

One Workbook = One Month = 4 Sheets per book.

I also have an aggregate sheet that keeps track of totals for a P/L for each month. Each workbook contains a template sheet that I copy as each week comes.

The problem I’m running into is table names. I want to keep every table in every sheet in the workbook with a standard name throughout the workbook. However currently, when I copy the sheet, a random integer is appended to the name of the tables. Is there a way around this?