Hi everyone,

Trawled the internet for an answer to this but cant seem to find the solution, hopefully one fo you guys can help me.

Scenario; I have 3rd party software that pulls reports in .csv files. I want to summarise this data into another spread sheet. Ideally I would like to save these files into a folder on the network and my summary workbook simply looks for this folder and is able to find data within all Excel files saved in there (new files will be added on a monthly basis).

Once it has found the folder there will be 2 pieces of data to evaluate;
Cell $B$1; this will be the name of a course (e.g. health & safety, money laundering etc.)
Column $D; this will contain the score achieved by multiple learners.

The summary spreadsheet then averages all of the scores for the different courses(in seperate cells)

The idea is that the .csv files can be pulled and saved into said folder and eliminates the need to manually input this data into the summary spreadsheet.

I hope this is doable and if so someone can help me along with this.