Your problem is very similar to this one: https://www.msofficeforums.com/excel...ta-source.html
The code can be changed to take the data from all excel files in a folder...
But , obviously or not, this is not the only way.