wild card in macro for worksheet lookup

hello

can someone pls help with a basic modification

Please Login or Register  to view this content.

the above is part of my macro....

the issue is, alot of the workbook are called "master zip sheet" "master zone sheet"

can i make a wildcard so it does it searches by "*MASTER"

i.e.
Set sourceData = sourceBook.Worksheets("*Master")

^i know that does not work...pls help!

Have you tried ("Master*")?