Data Mining out of an Excel Spreadsheet

Hello,

I am importing an Excel Spreadsheet in monarch so I can get the information into the correct order so it can be uploaded into another system.  However, many of the spreadsheets that I am getting has a "header" section much like a pdf would and I need to pull so information out of that to put in all of the detail lines.  For example Rows 1 - 4 is the header information while rows 5 & 6 are the column headers and then everything after that contains the detail information that I need.  What I would need to do is pull the information from rows 1 & 4 and add that to every detail line.  Does anyone have a good way of doing that with converting the file to a pdf as I will be getting hundreds of these files a month.