Copy two worksheets in new workbook where one sheet is constant

[jo.chi]

Dear all,

I hope you can help me! I really need this to be fixed so bad.

So I have 10 WS in a workbook. What I want to do is to copy every sheet to a new workbook, with a constant worksheet being copied as well.

In example

My worksheet names are in a single workbook is CODE / sheet1 / sheet2 / sheet3.... / sheet10.

What I want to happen is to copy two worksheet (where CODE worksheet is always copied) in new WB.

WB 1 is Code and sheet 1
WB 2 is Code and sheet 2
WB 3 is Code and sheet 3
WB 4 is Code and sheet 4
Etc

Thanks!!!!!

[arlu1201]

What should the new workbooks be saved as? And do you want them to be saved in a particular folder?

Also, should the new workbooks be left open after the copy paste or should they be closed?

[jo.chi]

What should the new workbooks be saved as?

The new workbooks should be saved as .xls (97-03 version). Also I'd like the new WB to have the filename using the Sheet's name not the CODE's name. i.e. Sheet 1.xls; Sheet 2.xls, etc.

And do you want them to be saved in a particular folder?

Yes. Maybe create a new folder for each new WB using its name as the folder name.

Also, should the new workbooks be left open after the copy paste or should they be closed?

It can be left opened.

Thank you very much arlu1201!