Refering to sheets with Variable Names

Hello,

I need help writing my code to work with worksheets that have variable names. In the code below. I want to be able to have it set up to work with any report that contains part of the below titles.


Windows("Regulatory Report.XLSB").Activate
Columns("A:A").Select
Selection.Copy
Windows("BOReport.XLSX").Activate

I want to be able to have my areas title their reports with a prefix for identification.
ex. Area1Regulatory Report or Area1BOReport

How can I get the code to recoginize a workbook title with a variable prefix?

Duplicate post due to forum problems
Thread Closed.