Consolidate multiple Excel 2016 worksheets into one

1124835 pts.
Tags:
Microsoft Excel
I'm using Microsoft Excel 2016 and my workbook contains roughly 15 sheets. I need to consolidate all the sheets into one specific sheet. Obviously, I could copy / paste but that would take way too long. All the data is in the same format. Thanks.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

To save several sheets from your workbook together in a new file, you can do the following in Excel:

  1. First select the sheets (you can select multiple by holding the Control key), and the right-click on one of them. Then choose “Move or Copy…
  2. Select (new book) and check “Create a copy”:
  3. After you’ve pressed the OK button you’ll notice that a new workbook is created with the selected sheets only:
  4. Now you have a new workbook with only the selected sheets which you can save as a new file.
 You can find the utility here: ASAP

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: