That is true, it is tough to find someone to start from scratch and simply do the work.
One step at a time...you can use the macro recorded (Tools>Macro>Record macro)
to record the code that does the import. In many cases that code can be modified to help you out, but you kind a gotta start somwhere.
Since we do not know
1) How many text files
2) What format the text files are in (comma delimited, fixed width) etc
3) The format they need to be in excel
etc
it is very difficult, as there is no "blanket" code for something like this.