How to make a copy of a Worksheet from the current Workbook to another Workbook?

  1. Open the Target Workbook, when the Source Workbook is already in open state.
  2. Right-Click on the Source-Worksheet Tab.

    Worksheet Copy

  3. Select the Move or Copy… option from displayed shortcut menu.
  4. Select the Target Workbook name from the To Book: drop-down list.

    Target Workbook

  5. Put a check-mark in the Create a Copy option and click OK.

There you are, you have a clone of the source worksheet on your Target Workbook.

Instead, if you want to move a worksheet to the target Workbook, select (Move to End) option.