How to import specified text from txt file into excel file

[svrm83]

Hello, I am looking for some help in importing some selective data from txt file to excel. Only the following rows I need to pull out from text file into the Excel i.e. Number, Name, Failures column. This is my logical procedure..
1. Macro look for the column "Name" and import below items to excel in a column.
2. Macro look for the column "Number" and import below items to excel in a column.
3. Macro look for the column "failures" and import below items to excel in a column.

Your help will be greatly appreciated. Thanks.

Example Text file looks like below:

Summary report
08/19/2014 09:48:05
Prog Name: XXXXXXXXXXXXXXXXXXXXXX
Job Name: XXXXXXXXXXXXXXXXXXXXXXX
Load File Name: XXXXXXXXXXXXXXXXXXXXX
Started at: Tue Aug 19 09:47:22 2014
Lot: XXXXXXXXXX_XXXXQ1R3
Operator: 10909226
Test Mode: Production
Node Name: U1111111
Part Type: 11111111111111
Channel map: Chans
Environment: QA
ExecType: IGXL
ExecVer: 8.10.00_uflx
FamilyID: XXXXXXXXXXXXX
FloorID:
JobRev: 124565
SetupID:
SpecName:
SpecVer:
SubLot:
TestCode: FT1
TstTemp: 110
UserText: QA


Site Number:
0
HandType: HT9045
HandID: 02
CardType:
CardID:
LoadType:
LoadID: xxxxxxxxxxxxxxxxxxxx
DibType: 11111111111111
DibID:
ContType:
ContID:
LasrType: 783
LasrID: QART2




Number Name Total Failures %/Part %/Exec
-----------------------------------------------------------------------------
0 FTOtpPreCk <> PrintRepairCounter 1 50 0 0
1 FailedMemOtp <> PrintRepairCount 1 0 0 0
2 NoRedundancy <> PrintRepairCount 1 76 0 0
3 NotRepairable <> PrintRepairCoun 1 0 0 0
4 NotRepaired <> PrintRepairCounte 1 0 0 0
5 Repaired <> PrintRepairCounterFT 1 0 0 0
500 Continuity_GND bs_clk 1 1000 0 0
501 Continuity_GND bs_hb 1 0 0 0
502 Continuity_GND bs_tc 1 0 0 0
503 Continuity_GND cmicm_chipid_to_s 1 0 0 0
504 Continuity_GND cmicm_chipid_to_s 1 0 0 0
505 Continuity_GND cmicm_chipid_to_s 1 0 0 0
506 Continuity_GND cmicm_eeprom_load 1 75 0 0
507 Continuity_GND cmicm_ext_uc_is_s 1 0 0 0
508 Continuity_GND cmicm_ext_uc_pres 1 0 0 0
509 Continuity_GND cmicm_gpio0 1 0 0 0
510 Continuity_GND cmicm_gpio1 1 25456 0 0
511 Continuity_GND cmicm_gpio2 1 0 0 0
512 Continuity_GND cmicm_gpio3 1 100 0 0
513 Continuity_GND cmicm_i2c_debug_m 1 0 0 0
514 Continuity_GND cmicm_i2c_sa0 1 0 0 0