Can I use wildcards to select a worksheet name? Or any other ideas?

[M.elissa]

I have created several new worksheets using the following which will change every month.

Please Login or Register  to view this content.

My Dilema is selecting the sheet (as named above) so that I can programatically paste selected data in their every month. Wildcards don't seem to work and I am doing this process for a number of sheets so I'm hoping there's a simple line?

Please Login or Register  to view this content.

Here's

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This is repeated many time, hence I'd like a simple line, not a complicated if statement - is this possible? Any help would be greatly appreciated.

Thanks in advance!

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[M.elissa]

Thank you, guess I had better do some rule reading!

[M.elissa]

Solved it!

Please Login or Register  to view this content.

In case anyone else has the same issue.