When you’ve finished adding data to a worksheet—such as at the end of a calendar month, when you create a new worksheet to store data for the next month—you might want to include the entire worksheet as part of a monthly overview to your general manager. Rather than keep all of the worksheets in their original workbooks and flip from document to document when you create your presentation, you can copy the worksheet from the current workbook (and any other worksheets with data you want to include) to a central document. Going from worksheet to worksheet is much easier than going from workbook to workbook!
Copy Worksheets within the Workbook
Hold the down Ctrl key and drag the worksheet you want to copy to the new location.
Caution
If you don’t hold down the Ctrl key while you drag the sheet tab of the worksheet you want to copy, you will just move the worksheet to a new location in the workbook.
Copy Worksheets to Another Workbook
Open the workbook that will receive the new worksheets.
Switch to the workbook that contains the worksheets you want to copy, hold down the Ctrl key, and click the sheet tabs of the worksheets you want to copy.
Right-click the selection.
Choose Move Or Copy from the shortcut menu.
Select the Create A Copy check box.
Click the To Book down arrow.
Click the workbook to which you want the worksheet(s) copied.
Click OK.
Tip
Select the New Book option from the To Book list to copy the worksheet into a new workbook.