process data in text file and import to worksheet

Could somebody please help me with this,

I have this kind of data in text file

Please Login or Register  to view this content.

I want to import only the data marked in red color to worksheet in the pattern shown in the attached file.

Please have a look at the data in the attached file.

Any help would be highly appreciated.

PS ref http://www.vbforums.com/showthread.p...10#post4127010