Need advice : consolidating data from multiple CSV files in Excel - External data handling
 

Hello everyone,


I'm quite novice playing with external data in Excel and I need some best
practice advices to achieve the following task :

Our customer asks us to consolidate data coming from 11 CSV files into 1
excel sheet. The CSV file are generated one a month by a billing app. As a
consequence, the data contained in the CSV files must be refreshed before
generating a new datasheet every month.

The existence of the CSV file isn't guaranteed (empty report), so I must
take this into account...

I would like to fully automate the data processing, using a big GO button.


Any advices, idea, experience ? Is Excel the good tool to do that or should
I use Access or even fully code it myself ?

Thanks !

Matthieu, Belgium