Fetching data from different .csv files

[saromaki]

Hello wizards!

I have a lot of .csv files in a directory and I'd like to combine the values from those into one file.

The filenames have a value (second 6-digit number) that I'd like to use as a header in the main file along with the date they were created on (it's also the first 6-digit number on the filename in format MMDDYY).

Example below:

The files have two numbers separated with a comma in A1.
Example below:

I'd like to fetch the data from these .csv files into one so that the values are divided into two fields using the second 6-digit number from the filename (e.g. 509209) and the date as headers.
Example below:

Is this even possible?

Thank you for your time

 

[smozgur]

I think the description is not complete.

For the sample 6-digit number, 509209, there are four different CSV files for the same date (and it's the same for the other 6-digit numbers). However, your result sample extracts only one CSV file content. If the other three files had different name signatures, then I would have thought of extracting their content as new rows with the associated dates, however, that's not the case and they belong to the same date.

What is the application logic for the other files that include the same 6-digit number?

 

[saromaki]

You're right, I was being unclear about the wanted output. Let me show you the wanted output for number 509209 (for 5th of Oct. 6th and latter days should be fetched below these accordingly). And having more thoughts the other numbers can be combined similarly to other sheets.

If it is possible to sum all the values per day, then that would be the best output...

 

[saromaki]

Never mind! I solved this Simple get from folder.