Select Multiple Worksheets based on Cell Array

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.

Try something like this...

Please Login or Register  to view this content.

That worked perfectly, you saved me a huge headache! Thanks.