Hello,
I have been using the Like operator in VBA to activate sheets if they have a given start to their name. See example below:
Sheet name = "AI. 1234567"
Identifying start to name = "AI."
The code for this would be as follows:
For Each sh In Worksheets
If sh.name Like "AI.*" Then...