copy multiple files into different sheets

[Rodrigues]

Hi There
I would like to copy data from different files into a individual sheets on a daily "master" file, without to have to open the source files using vba, in the easier and simplest way possible.

Example:
Folder C:\PA

25 CSV files from 2017-07-04 Batch Yield Report 0000-0059 until 2300-2359

(some source files examples):
2017-07-04 Batch Yield Report 0000-0059
2017-07-04 Batch Yield Report 0100-0159
2017-07-04 Batch Yield Report 0600-0659
2017-07-04 Batch Yield Report 2200-2259
2017-07-05 Batch Yield Report 2300-2359 (last one and has next day date, however the data belongs to the previous day (4th), so needs to be copied with all of 4th date files too.

The data on each file needs to be pasted on each individual sheet on "daily master" file
2017-07-04 Batch Yield Report 0000-0059 (first file) - Sheet1
2017-07-04 Batch Yield Report 0100-0159 - sheet2... and so on
2017-07-05 Batch Yield Report 2300-2359 (last file) - sheet25
I'm currently running loop directory but only copy the data into sheet1 and for whatever reason when past the date onto column B (master file) changes the date format.
Could someone please help.
attached are some files for better explanation, "master" file shows how do I need the data to be pasted.
Thanks in advance.
R

 

[Monty]

Try this!

This should work for you!

https://www.chicagocomputerclasses.com/excel-vba-loop-though-all-files/

 

[Rodrigues]

Monty
Thank you so much for your help.
It comes up with syntax error on

If .Show <> -1 Then GoTo AllGood
            DirPath = .SelectedItems(1) & "\"

Could you please help me?
Thanks again.