How do I get my Macro that references 12 tabs named after each month to auto change if I change the tab names

[KRE]

I have Macros that reference tabs that represent each month as in the screen shot below. If I change the names of the tabs for instance "dec" to "DEC24" how do I get the macro screen shot below to auto pick up that tab name?

 

[Micron]

Maybe like

Dim sht As Worksheet

If Left(sht.Name,3) = "DEC" Then
    'do something
End If

I suspect you could integrate all of those into one sub. How that would look depends on what you are doing to run any one of them. It does not look like that is a command button.
Please use code tags (vba button on forum posting toolbar) and not pictures of code.

 

[Micron]

What I posted is not correct and I can't edit it now. That approach would be used when looping over the sheets, which may not be what you want to do.

Dim sht As Worksheet

For Each sht in ThisWorkbook.Sheets
    If Left(sht.Name,3) = "DEC" Then
    'do something
End If
Next

You could also refer to the sheet by its code name instead of the sheet tab value. The code names are shown in the objects list for the vba project.

 

[KRE]

The reference to the sheet by its code name worked! Thank you!

 

[Micron]

Glad I could help and thanks for the recognition.