Private Sub CommandButton1_Click()
Sheets(Sheets.Count).Copy after:=Sheets(Sheets.Count)
With ActiveSheet
.Name = Format(.Range('E16'), 'mmm yy')
.Range('F10:G10').ClearContents
.Range('C20').Value = .Range('C20').Value + 1
.Range('C16').Value = DateAdd('m', 1, .Range('C16').Value)
End With
End Sub