copy all sheets after shee5 (or specifically named sheet) to a new workbook

Hi All

I have a workbook in which excel uses data on the first 5 sheets to create multiple sheets with names dependant on that data.
What I want is to use VBA to copy the newly created sheets (could be between 1 and 30 new sheets) into a new workbook.
The easiest way to do this, I believe should be to say "all sheets after the sheet named "CONTEXT_PAGE".move (if you know what I mean)

Is this possible? Can anyone give me an idea of how to do so?

I can't attach the file as it contains a lot of sensitive data.

Originally Posted by TMS

What might be easier is to copy the entire workbook, loop through all the sheets in the copy workbook converting everything to values and then delete specific named worksheets. You can't rely on any worksheet being in a specific position in the workbook.

Good idea, do you have a sample code which would do similar? I’m a bit of a beginner! I can on the other hand rely on the first 5 pages not changing position (all new sheets are created after the first 5 and no additional sheets need to be added to the five data sheets)