Excel - Move or Copy Sheets between Workbooks

Move/Copy Sheets between Workbooks in Excel

There are time that you want to reuse a sheet from an existing workbook or you need to move a sheet from one workbook to another. This feature allows you to do that with ease from the format menu in the Cells group of the Home tab. First, Open the sheet you want to move or copy. From the Home tab:

1. In the Cells group, click Format
2. Under Organize Sheets, select Move or Copy Sheet       
3. Choose where you want the sheet to be copied or moved to    
4. Be sure to select the create a copy box if you do not want your sheet moved