Importing Multiple Files into Excel 2010

[javeds]

I have files (with .ill extension) in individual folders (that have other files in them as well) that I would like to import into Excel as separate worksheet in one workbook. By using 'get external data, 'from text', and 'text to column, space-delimited' I can easily import these into Excel. However, there are 1000 such files and it would be great if I can automate this process - naming each tab with the name of the file (picture attached). Thanks in advance for your help!