compiling csv files from multiple PCs
 

I have a program that creates output files in csv format. The program runs
several times a day - 10 times one day, maybe 15 times the next. It also
runs on 2 different PCs. I want to do something that grabs all these files
and compiles them into a single file every day. Each file has a date and
time stamp on the end of the filename.

How can I do this in Excel if I don't know whole file name or how many files
there are?