import multiple txt files to individual worksheets

[gottano1]

Hello all,

New here so please excuse any info I may omit.

I'm trying to come up with a way to import multiple (10) txt files into a workbook each on a seperate and specific tab (ie.. 001.txt to tab 001 and so on). The txt files are located on my C: drive and I'd like to do this with as little manual intervention as possible.

Office 03

Any help would be greatly appreciated!

[p24leclerc]

What is it you have in your text files? Single column of data or multiple columns?