if your talking just a one time  copy .. easy... select the sheet  tabs you want
to copy... right click on the tab and in the menu select copy/move in the pop
up select make copy  and the in the drop down along the top select new
workbook... click ok and it creates the new workbook  with the sheets  you
selected and the sheet names  as well.. if you want to automate it or do it
multiple times.. record the macro of you doing the steps and then you can just
run the macro..