Hi again Luckyros,

Got most of it done. The numbers in the workbook name and the worksheet name
I am assuming change with each workbook and that the worksheet numbers match
the numbers in the workbook name. Is this correct?

If my assumprion is not correct then which part of the workbook name and the
worksheet name changes? Show it like the following where the question marks
indicate the characters that are variable.

Workbook Name:
Agent Call Report_??????_??????_anactan.xlsx

Worksheet name:
Agent Call Report_??????_??????

It's 11pm here now so will not get back to it until tomorrow.

--
Regards,

OssieMac