Referencing Sheet Code name

Originally Posted by TMS

What is the structure of the workbook you are opening? How many worksheets are there? If it's just one, you can use Sheets(1) without needing to refer to the sheet name or sheet code name. If there's more than one, you can loop through them checking the sheet name, or part of the sheet name. What does the sheet name look like? Is there any part uniquely identifiable?

Perfect! Thanks for the solution and the assistance TMS, works well.