Import Multiple Text Files into Single Workbook with Different Sheets

So I've looked around and found several similar threads but nothing that I've been able to adapt and implement for my particluar project.

I'm trying to create a macro that will allow the user to select a folder containing several text files (all with the .log extention), and will then import each file within the folder with a separate sheet for each file. So far I've managed to adapt a code from a different thread to import a singe file, but I've been unable to adapt it further towards what I actually want. Also, if possible, I would like each sheet in the workbook to be named after the file that was imported into it.
Here's what I have so far, this code is working fine for importing single files and the import parameters would be constant for all files that would be imported.

Please Login or Register  to view this content.

Any advice or assistance that can be offered would be greatly appreciated. Thank you in advance.

Thank you so much! That works fantastically!

Now, to build on this further, is there any way of using a range on one sheet of the workbook to identify which files to import, say by having the directories for each file in a list, rather than selecting them one by one?

This range would have to be dynamic, so that the number of files that would be imported could vary.

Any further help with this project would be greatly appreciated.