Creating a new excel workbook - newbie help!

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!!!

Fabulous - I shall try this now

Ok - sorry if this is a silly question but do I simply copy the code above between the following two lines?

Private Sub CommandButton8_Click()

End Sub

you can assign the macro to the command button or insert the code as you propose.

to assign the macro, select developer, then click on design mode,
now right click on your button and select assign macro,