He has some amazing articles on his website, and I am going to copy this tip shamelessly here [with his permission of course] If you have a workbook where the tab’s names are numbers (for example 1, 2, 3.. or 2020, 2021, 2022..) then you are going to love this tip. Here it is – Give the desired number to your tab and put it in round brackets – (1). Now when you create a copy of the worksheet, the number automatically gets incremented by 1. So (1) becomes (2). Similarly (2013) would become (2014) when a copy is created.

Why Tab Numbering Trick Works

When you create a copy of a worksheet named Sheet1, it becomes Sheet1 (2), as excel can not have two sheets with the same name. Similarly if copied again, it becomes Sheet1 (3) and so on. So now when we name it (1) and copy it, the number is automatically increased by 1. Other articles you may also like:

How to Change the Color of the Sheet Tab in ExcelHow to Sum Across Multiple Sheets in Excel? (3D SUM Formula)Excel Tabs/Sheets Not Showing – How to Fix?