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!