How to copy n worksheets from an Excel workbook to another workbook

Generally encountered the title of such a situation, many people may be a copy of the paste, in fact, it does not have to be so troublesome.

You can do this by following these steps:

First step: Open all Excel workbooks you want to work with

Second: Hold down the SHIFT key, select all the worksheets you want to copy, and right-click on the selected worksheet

Step three: In the pop-up menu, select Move or copy (M) ... Options.

Fourth step: Select the target workbook to move to in the new pop-up window, and place the position. Click OK to transfer the success.

How to copy n worksheets from an Excel workbook to another workbook