Question: how to copy a worksheet from one workbook to another in excel 2010?
Answer: If you want to move or copy the selected worksheet(s) to a new workbook rather than to an existing one that you have open, select the (New Book) option at the top of the To Book drop-down list. Use the Move or Copy dialog box to move or copy worksheet(s) from the current workbook to another workbook.