Combine tabs from multiple workbooks into one

G

Guest

I was given twelve workbooks (one for each month). Each workbook has one tab.
What is the fastest way to combine the twelve workbooks (thus the twelve
tabs) into a single workbook? I can open each workbook and move each tab
individually, I just thought there might be a more efficient way. Any ideas?
Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clustering worksheets 1
Merge Multiple workbook sheets into one workbook 0
Combine multiple workbooks into 1 workbook w/ multiple worksheets 2
Combine multiple workbooks into 1 workbook w/ multiple worksheets 2
Serious Excel Challenge 0
Combine multiple workbooks into one workbook 1
Merging Workbooks 2
Combining Text from multiple workbooks 1

Top