Depends on what you're doing...
If you're combining all the text files into one worksheet, then you could
combine the text files into one (outside of excel), then import that giant text
file once.
Shell to DOS
traverse to that folder that holds your text files
copy a.txt + b.txt + c.txt all.txt
But if all your files to combine are in a folder that contains nothing else that
can be intermingled:
copy *.txt all.txt1
(changing the extension on the "to" file name will allow DOS to concatenate
without trying to include the "to" file itself.)
===
If all the files will go into separate worksheets (workbooks), but are laid out
the same way, you could record a macro when you did one, then just replay that
macro for the remaining.
so it depends...
