Defined Names in Formulas when copying Worksheets in a Workbook

[Todd_Loves_Spreadsheets]

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?

 

[JLatham]

Perhaps this discussion over on Chip Pearson's site will help you out:
http://www.cpearson.com/Excel/DefinedNames.aspx