Collate multiple Excel files into one worksheet

[DrPudding]

I have multiple files that are the exact same data format, all the same columns but different data, and I want to be able to select all of these files and get them to all compile into one file in one worksheet. As they all have the same headings they would just need to be copied one below the other.

This is a simple manual process, but I will need to do this regularly with sometimes 20 or more files at a time.

Is there a way I can automate this with VBA?

 

[sandy666]

if all excel files are in the same folder try Power Query with From Folder option then Append feature if necessary

 

[DrPudding]

Just had a Google of power query, and this is the exact perfect tool for what I need. Thank you muchly for your suggestion.

 

[sandy666]

You are welcome
Have a nice day ?