Ok, i've been given a new project which is completely outside of my skillset, but something which I am sure is achievable and as such can't wait to start. Preferably in the right direction...

I am after building an excel file which will read in specific data from numerous other CSV files which all reside within one master folder. Once I have the data I have plans to get specific details from it but this is my first step. Pulling data in from numerous different CSV files without the need to manually import each time a new CSV is added to the respective locations.

Have I bitten off more than I can chew at this point or can someone point me in a starting direction?

Cheers

Mike