Are all your source files in the same structure?

This is straightforward with Power Query (Get & Transform Data). Post sample workbooks.