I have a macro that uses a template invoice to create a invoice sheet, also naming the sheet based on the invoice number (So I will fill in a cell invoice # as 57, fill out the rest of the sheet, run the macro, and it will create a sheet named "MIS - 57", or whatever invoice number I have filled in, then bring me back to the blank template form)

By the time I am done creating my invoices, all of the sheet names that I have created are listed on the side of my template form (Cells A1-A10 may have: MIS - 57, MIS - 58, MIS - 59 etc)

Is there any way that I can select all of the sheets I have created, based on the values in the template sheet?

Here is what I want to be able to do. Open the file, only 2 sheets initially, Summary and Template. After I have finished creating my invoice, I want to be able to move all of the Sheets I have created to a new workbook, so I will then be left again with just a Summary and Template page.

I dont know how well all of that translated, hard to verbalize sometimes. Thanks for any help.