Import multiple text files to different worksheets in Excel for Mac

Hello,

I have around 800 .csv text files from a building's energy monitoring system (one for each day) which I need to import to Excel 2011 for Mac. I have had no trouble importing one or two of these files manually, but a macro would help me save a lot of time. However, I've tried using several macros I found in this forum and others but haven't had any luck with them.

Ideally, I would have one worksheet for every text file.

My folder's address is "Macintosh HD/Users/Bertram/Desktop/SMER3/2012/08_2012".

Any help?

Thanks in advance.