Macro to append multiple excel files in one excel file

Question

I have a folder having multiple excel files each having one single worksheet which contains exact data with same columns. i want a macro to help append all the excel files data one below the other into one new excel file .
I tried using vba code from "Append data from multiple excel files RRS feed
Archived Forums 421-440 > Visual Basic for Applications (VBA )". But it is not working

kindly help

Answer 1

You can do it easy using Power Query. That for a start:

If you must do it in code then loop, open files, find data on tabs and copy to single one. That is not easy way.
I create tool for it before PQ exist: hQlGjMo8fws

Regards