Have you had a look at power query?


https://www.myonlinetraininghub.com/...-from-a-folder


This can combine files really easily with very little time invested.


The alternative is VBA, but that will take a bit more planning and anm understanding of coding