how to copy tabs from one excel sheet to another?
Click the sheet tab in the source workbook and drag it to the target workbook. If you want to copy the sheet instead of move it, hold down the [Ctrl] key while you drag the sheet to the target workbook.