Combining multiple files into one

Hi all,

I have multiple excel files in a folder that I would like to combine them all into another excel file. Each time a new file is uploaded to the folder, the excel file should be updated without making changes to the old ones.

I tried using Power Query or Power BI but it keeps returning some errors hence why I'm looking for VBA/Makro help here.

Is there a VBA/Makro code I can refer to in combining the files?

Thanks!