How do I create a new work book with selected worksheets
 

I have about 25 worksheets in one workbook. These are linked to a summary
sheet of approx 2500 lines. I want to created a €œhomepage€� where I can
select say 5 of the worksheet and create a new book with just the five sheets
and the summary sheet. Would someone be willing to share the code that would
allow me to do what Im looking to do?
Id greatly appreciate any assistance!
PS I'm a real novice at this

Brian