Moving or coping a worksheet
You can change the placement of the worksheets in a workbook. To reposition a worksheet, you click and drag the sheet tab to a new location relative to other worksheets in the workbook. To copy a worksheet, just press the Ctrl key as you drag and drop the sheet tab.
Right click on your required sheets or sheets, select “Move or Copy” option. New window appear. Now select your required destination and place of worksheets. If you do not want to move your worksheets then enable the check-box named “Create a Copy”.