I have workbook that has multiple sheets. When I push out a new version of this worksheet I want a user to be able to click a button to export all the sheets except "1" and "2" (for example) to the new workbook.

So...
1. the user clicks the button
2. All sheets are copied except the three I specify in the VBA
3. The screen comes up to allow the user to choose the workbook to export the sheets to

I haven't been able to find anything on moving multiple sheets like this on the internet, only methods to move a single sheet (with a static name).

What might this code look like? I really appreciate any help you can give me.