If he teaches you VBA, I think you should rely on him instead of this forums.
For instance, as he said, the sheet1 can be named as 2020/11,
I doubt it. Unfortunately, Excel does not allow its sheet names to contains slash (/).
But You can name it "2020-11" or "Nov.2020" instead of "2020/11".
' NG
' Sheet1.Name = "2020/11"
' OK
Sheet1.Name = "2020-11"
Sheet2.Name = "2020-12"
Sheet3.Name = "2021-01"
and then I can set a command button, which the next sheet (2) named 2020/12 can pop out as I click it. Moreover, the sheet(3) name will be 2021/01,
Option Explicit
'
' This workbook contains only SINGLE worksheet, and the worksheet name is "2020-11".
' If your book contains tri-sheets, let's try to write the other code yourself.
'
Private Sub CommandButton1_Click()
Dim firstSheet As Excel.Worksheet
Set firstSheet = ThisWorkbook.Worksheets(1)
Dim lastSheet As Excel.Worksheet
Set lastSheet = ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count)
Dim firstMonth As Date
firstMonth = CDate(firstSheet.Name & "-01")
Dim nextMonth As Date
nextMonth = DateAdd("m", ThisWorkbook.Worksheets.Count, firstMonth)
Dim newSheet As Excel.Worksheet
Set newSheet = ThisWorkbook.Worksheets.Add(After:=lastSheet)
newSheet.Name = Format(nextMonth, "yyyy\-MM")
End Sub
