You are here:

Excel/Combine tables/spreadsheets



I have over 25 excel tables, each table has at least 15 sheets and I need to find a way to combine different sheets from those different tables into a new single table. Is it even possible?
I DO NOT want to consolidate and bring total dollar amounts from those tables.
Is there any way I can do that with a formula, macro, function or anything else besides the time consuming copy/paste function ?
Thanks ins advance.

ANSWER: Typically there is a way to combine sets of data using all the approaches you've mentioned.  As much data as you're describing is certainly a non-trivial question, VBA would be the method I would use, most likely a couple hours work to devise a macro specifically to combine your unique tables/workbooks into a master of some kind.

The other benefit of a macro is that it is reusable on future sets of like-formatted data.

---------- FOLLOW-UP ----------

QUESTION: Thanks a lot and I'm sorry for giving you a late feedback.
Could you suggest a way for me to learn how to do what you suggested, a macro specific to my needs? is it too complicate to learn ?
Or I  would be better of by hiring someone to do it for me ?
Thanks in advance and I'm leaving you a feedback at the same time.


A question this complex would undoubtedly take weeks to cobble together if you have no working VBA basis to work from.   I have an extensive basis and have performed this specific task 100s of times for clients, which is why it is a known and manageable thing for me, but is certainly not a trivial task.  It would take significantly longer for me to try and coach you through it as well.  

My recommendation is you hire me or someone closer to home to do it for you.  I can do it in about 2 hours if I have 2-3 sample source workbooks and a sample mockup of the results you would expect from those 3 source workbooks.  From there I can construct the tool that will work for you on an unlimited number of source workbooks in the same folder.

My completed project would come with a complete set of comments explaining what each line of the code does, and thus should be very informative from a learning perspective.

If this is acceptable to you and wish to pursue it with me, please contact me directly through
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


Jerry Beaucaire


Excel Formulas, macros, automation. Microsoft Excel MVP - 2010. Code site with free code snippets and techniques:


Microsoft Excel MVP - 2010. I have my own extensive Excel help/code site: ===================== I have been offering free assistance as an Excel aid on many web sites for many years: ( - JBeaucaire) ======== ( - JBeaucaire) ======= ( - jbeaucaire)

Bachelor's Degree from Azusa Pacific University in Mathematics and Music Composition

Awards and Honors
Microsoft Excel MVP 2010

©2016 All rights reserved.