copy several tabs from worksheet to worksheet

edsquestions 

I assume that you want to copy worksheets from one workbook to another workbook. You can do this as follows:

• Open both the source workbook and the target workbook.
• Activate the source workbook.
• Select the worksheets that you want to copy.
• If they are adjacent, click on the first sheet tab, then hold down Shift while you click on the last sheet tab.
• If they are not adjacent, click on the first sheet tab, then hold down Ctrl while you click on each of the other sheet tabs that you want to copy.
• Right-click any of the selected tabs.
• Select Move or Copy... from the context menu.
• Select the target workbook from the To book: dropdown.
• Specify where you want the copied sheets to end up: before a specific sheet, or at the end (after the existing sheets).
• Tick the check box Create a copy.
• Click OK.