How do I understand the effects on Table names when copying a worksheet
within a workbook. I am new to Tables and Defined NAmes. I have formulas
that work on one worksheet but when I copy to use for next month in a
workbook my name scopes get confusing.

Every Table name appears to be Workbook scope and a copy adds a number
representing the next table number added to the workbook. So I have defined
tables (Monthly_Sales, Monthly_Sales1, Monthly_Sales12, Monthly_Sales123,
etc.)

Is there a better way?