Hi All

Hope someone can help. Am sure this is probably simple for those in the know
Bear in mind my knowledge is basic to say the least!

I have a workbook - lets call it workbook "X" and within workbook X I have 8 worksheets.

I would like to have a command button on a worksheet in workbook X, which when I press it, copies worksheets 2,3, 4 and 5 only into a new workbook called workbook Y.

I managed to create the command button and then by playing around and using:

Private Sub CommandButton1_Click()
Sheets("2").Copy
End Sub

I managed to create a workbook with 1 sheet in but have no clue how to add the other sheets in and to save it as workbook Y.

Any help gratefully received!!!