I’m with Belinda, Power Query pretty much wears tights and a cape in my book. Power Query for Excel: Combine multiple files of different file types
Power Query for Excel: Combine multiple files of different file types « PowerPivotPro
Archived post from 2015. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.