"Advanced" Text file importing
 

Hi All,
I am receiving a quite large number of tab separated text files with
information each week (50+), that I need to import into an Excel sheet and
then work with=produce reports :(
It is quite time consuming to run the File import utility for each file, and
I would therefore like to create a macro assigned to a button that should do
the following.

For each text file in a folder, sorted by file name or creation date, do the
following:
1. Import the tab separated data, and append it to the already existing data
in the active sheet. The information should be imported like the example below
2. Move the file to another folder, an "archive"

If I have this I can easily create a rule in Outlook that stores my text
files in a certain folder, open excel, push the button, and be ready to work.
Would be great!

The file that should be imported looks like this:
Header1
Header2
Colummn Header 1 Column Header 2 Column Header 3
ROW1-1 ROW1-2 ROW1-3
ROW2-1 ROW2-2 ROW2-3
ROW3-1 ROW3-2 ROW3-3
Footer1
Footer2
Footer3

Ideally, I would like the excel spreadsheet to look like this:
Header2 ROW1-1 ROW1-2 ROW1-3
Header2 ROW2-1 ROW2-2 ROW2-3
Header2 ROW3-1 ROW3-2 ROW3-3

I have tried to write macros for this but cannot make it work. If all cannot
be done (I realize this might be quite complex) I would appreciate any help
with getting as close as possible to the ultimate solution!

Many thanks,
David