That's worked. All done sir. Been a pleasure working with you.

For my own education purposes. I have a few questions.

1. What is intersect and what function does it perform in that code?

2. Can you explain to me how the below copies the sheets and pastes in the exact formats as required into a new workbook? What does the array function do? How comes you don't need to declare?

How do I acknowledge your expertise?

Sheets(Array("Mainstay Master", "Mainstay Report")).Copy