Come on dude. You ain't even trying on this one. Send an administrator.

Hi Bradley,

Please have some respect and patience.  You are getting free help here.

regards

Phil

Hello Bradley,

Great that it works as you want. As long as the structure is the same in all files, i.e. the number of rows and columns are the same, it will work. The file I provided was just a simple quick fix solution.

With Power Query you can do a lot and if you take time and learn how to use the advanced editor and work with the M functions, then you are set to do advanced stuff.

Br,
Anders