Consolidating 10 excel files data in to one excel

[sanojk]

Dear All,

I have 10 csv files. Each one contains some values. I Can able to generate the count of one column(eg: count of Colum A) of all sheets in to a separate Excel sheet(Eg : Summary.xls). My requirment is that when I copy the Summary excel sheet in to a folder which contains 10 CSV files, the count(eg: count of Colum A) should get genrate automatically in to Summary sheet. Note that the 10 CSV files name will change daily basis.

Can anyone help for me please

Regards,
Sanoj