How do I merge/combine different workbooks with different sheets

  • Thread starter Steve Descharme
  • Start date
S

Steve Descharme

I have several workbooks each with one worksheet. These worksheets are all
named something different. I want to combine/merge these workbooks into one
workbook containing all the single sheets. I can't use the "share and merge"
because these workbooks were created separtely and not copied from one
workbook. I have over a 100 workbooks with 1 sheet per and do not want to
copy and past each one.
 

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

Use a master workbook to carry over changes to multiple workbooks 1
Consolidation Table from Different Excel Tabs with Different Format 1
move worksheet to end of another workbook 7
Auto Merge text from multiple sources 0
combine multiple workbooks? overcome 255 character limit? 3
How to combine or import multiple Excel workbooks? 6
Copying Worksheets From Different Workbooks using Marco 4
Totals of different worksheets. 2

Top