VBA Gather data from multiple files and sheets

[erikavb04]

Hello,

Every month I get an update of data which is given in different files and sheets (see files "DataFile01 & DataFile02").
What I always do, is that I gather them in 1 table (see file "DataTableResults").

See files:
https://drive.google.com/open?id=0B00gFmdiXOT4NnlHcGVlOG5PTUE

I have always done it manually which takes me a lot of time, now I would love to let it run automatically.
Can someone help me with this pls?

When gathering the data, the following things should be taken into account:

• Amount of tabs vary per file
• Amount of data length (total rows) vary per sheet
• When pasting all this data into 1 table, it should always overwrite the existing data in the table

Thank you very much for your help.

Kind regards,
Erika

 

[AlphaFrog]

Here's a free add-in that consolidates workbooks.
RDBMerge, Excel Merge Add-in

 

[erikavb04]

Hi AlphaFrog,

Thank you for the fast reply, the Excel Merge Add-in is amazing!
Very nice tool of Mr. de Bruin, it will perfectly do the job .

Thanks again.
Erika

 

[AlphaFrog]

You're welcome. Thanks for the feedback.