Append many imported files to a worksheet

In the modified code below I am trying to import text files (.OUT) and append each file by rows onto sheet 4.
What I get is each file plastered about the worksheet.
Some of the data is properly entered in columns "A thru H" and some of the files append rows within the same columns while others are placed in columns "I thru P" in the same rows and others are further out in the columns.

Please Login or Register  to view this content.

Any hints, tips and or examples are appreciated.
See attached excel file of sheet 4.

I found some code tht required a few edits to make it work, credit to Andy Pope.
http://www.excelforum.com/excel-prog...ng-macros.html

Please Login or Register  to view this content.