1. -- make sure that the target workbook is open in the same instance of Microsoft Office Excel. *Note: you can check that are in the same instance easily on VIEW menu | Window section | Switch Windows button 
   
   
2. -- Select Source Worksheet(s) 
   
   
3. -  Get to the Move/Copy worksheet Dialog  => On the Home tab, in the Cells group, click Format, and then under Organize Sheets, click Move or Copy Sheet. Or Simply (and more intuitively right-click a selected sheet tab, and then click Move or Copy. 
   
   -  Select the destination workbook from the drop down list  and check 'create a copy checkbox' 

Move or copy worksheets to another workbook

1. To move or copy worksheets to another workbook, make sure that the target workbook is open in the same instance of Microsoft Office Excel.

    Note    You cannot move or copy worksheets between workbooks that are open in separate instances of Excel. If a workbook is opened in a separate instance of Excel — for example, this can happen when you open that workbook from a Windows SharePoint Services site — make sure that you open that workbook in the same instance of Excel instead by browsing to it in the Open dialog box (Microsoft Office Button , Open).

2. In the workbook that contains the sheets that you want to move or copy, select the sheets.

   How to select worksheets

   To select	Do this
   A single sheet	Click the sheet tab. If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.
   Two or more adjacent sheets	Click the tab for the first sheet. Then hold down SHIFT while you click the tab for the last sheet that you want to select.
   Two or more nonadjacent sheets	Click the tab for the first sheet. Then hold down CTRL while you click the tabs of the other sheets that you want to select.
   All sheets in a workbook	Right-click a sheet tab, and then click Select All Sheets on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.).

   Tip  When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

   Keyboard shortcut  To move to the next or previous sheet tab, you can also press CTRL+PAGE UP or CTRL+PAGE DOWN.

3. On the Home tab, in the Cells group, click Format, and then under Organize Sheets, click Move or Copy Sheet.

   Tip  You can also right-click a selected sheet tab, and then click Move or Copy.

4. In the Move or Copy dialog box, in the To book list, do one of the following:
   • Click the workbook to which you want to move or copy the selected sheets.
   • Click new book to move or copy the selected sheets to a new workbook.
5. In the Before sheet list, do one of the following:
   • Click the sheet before which you want to insert the moved or copied sheets.
   • Click move to end to insert the moved or copied sheets after the last sheet in the workbook and before the Insert Worksheet tab.

6. To copy the sheets instead of moving them, in the Move or Copy dialog box, select the Create a copy check box.

    Note    When you create a copy of the worksheet, the worksheet is duplicated in the destination workbook. When you move a worksheet, the worksheet is removed from the original workbook and appears in the destination workbook only.

Tips

• To rename the moved or copied worksheet in the destination workbook, right-click its sheet tab, click Rename, and then type the new name in the sheet tab.
• Worksheets that you move or copy to another workbook will use the theme fonts, colors, and effects that are applied to the destination