Copy specified data from notepad to excel

I have a several notepad text files saved in a location. I need a macro to get a section of information from each file to be copied to an excel sheet depending on the file names listed in column A of the sheet. The text file has data in the below mentioned format with each data separated by lines(---------------------),

HTML Code: 

if column B's header is DVB, the below data should be as copied

DVB:

xxxxx xxxxx
xyz:xxxx
xxx

xxxx xxxxx xxxxx

likewise if the header is ABC, then it should copy

ABC:

xxxxx xxxxx
xyz:xxxx
xxx

xxxx xxxxx xxxxx

xxxx xxxxx

all the data from the header name(ABC) till the end of particular header's data that is till the line(-------) needs to be copied.

Need help on this..Thanks in Advance!