How to load multiple files into separate worksheets?

Hello

How can I open c:\a.txt to worksheet A and c:\b.txt to worksheet B?

Obviously the above is to be done for many files so I need a neat way to do it and maintain a file list.

Thanks!