Using the .Copy method without an argument will open a new workbook  and
put the sheets  in it. For instance, this code  copies two sheets from the
open workbook into a new one:

Sheets(Array("Sheet1", "Sheet3")).Copy