Importing select data from Notepad to Excel, but not repeated headers

I have a couple hundred pages of trend data (in notepad) and I would like to move it into Excel. However, at each page break there is an automated message/header repeated. I do not want this information to come over. I know a few different ways to prevent that from happening, but I wanted to know if there was some sort of macro/automation I could create and it would do this automatically, i.e. delete all non trend data. Something that I could apply to all future trend data files I receive in the future as well.