Import multiple .csv files from folder that updates each day

Hi all, I have a folder that is named log1, everyday a new .csv file is added creating a log file and I am trying to create a sheet inside of excel that updates everyday with the data. I can import the external data but it only grabs the first .csv file and leaves the rest.Someone please help.

Check out this info from Ron Debruin...I think it may be what you are looking for.

http://www.rondebruin.nl/csv.htm

Hope that helps.