Code to extract Data from a list of Files

Hi Folks

I have/will have a large list of Files to extract Data from (with Formulas)-
The Files are all CSV files and are in the same location/folder-

Data is required from 3 Cols within each file and all files have identical layouts-

In the attached example Workbook I have formulas to display the requirement for each of the 3 Cols-

I have not attached one of the actual files as the example formulas display the path/s-

Cheers
hammer