Consolidating Similar data from sheets with identical headers

[ECB]

Hi there,

I hope you are all well.

I'm trying to work through what seems a relatively simple problem.

Let me start at the beginning.

I've set up a survey, and the output is in a csv file. There are 40 headers along the top.

There are six data collectors and all their data goes into their own csv files, which are uploaded to one drive nightly. The file headers are identical for all the csv files. The csv files change daily as each data collector adds to their files.

I'm on a mac, and I've managed to set up a spreadsheet with Power Query which pulls all the data from the csv files into worksheets. Works great updates every time I open the spreadsheet.

I want to summarize the entire dataset. I want to have all the data from the 6 sources in one sheet/one csv file.

I don't need that data to be transformed, or manipulated, instead of 6 sources with 100 lines of data, I want 1 sheet with 600 lines of data.

The data ranges in each source change every night (increase), can anyone suggest how to do this?

 

[ECB]

I'm trying to do this on a mac. It seems possible to do it on windows through power query get info from folders.