I know this is potentially not what you're looking for, but if I'm understanding correctly, you could use Power Query to achieve this.
This would work well assuming the files are in the same/similar format. It largely depends on what you're end goal is.

I won't go into anymore detail yet because it is probably not what you're looking for but let me know if you want to explore this further.