Converting multiple lines to one and merging workbooks

So I've been tasked to combine 92 unusable workbooks into a single useful workbook. The attached workbook is an example of the 92 headaches I have. I'm not much of an excel guru, more of a script kitty (kid-die is censored? lol), but I know that if I hand-jam all the data it will take me forever.

If you're looking at my attachment (attachment data has been sanitized to protect the actual data, sorry) you will see six "blocks" of data. What I need to do is pull the data from all 92 workbooks and put it into one workbook presented like columns N-T in the attachment. The source workbooks are always three blocks across, but don't always contain the same number of blocks. They are located in the same columns, but don't always occupy the same rows because each block doesn't always contain the same amount of data. The blocks always have the same heading; listing the worker, start location, info1, and info2. What changes is the number of white lines below each of the yellow "Time, job @ location" lines. The comma and @ sign always appear in the yellow line. The date column is derived from the file name of each workbook. The dates in the file name appear in alphabetic format ie June 1 = GR, June 2 = GS, June 3 = GT, June 10 = HA, and Aug 31 = KE... if that makes any sense... the file names all start with (X) followed directly by there alphabetic date AKA GR. So a workbook's file name might appear as (X) GR.xls

Hopefully I've described the problem adequately. I don't even know where to start with this... please help.

Do the comma and at symbol ALWAYS appear in the text?

In Column N, your header is Date, but you don't show a Date in the data. Is the date part of Time?

I assume the worker name is in Blue?

Welcome to the forum, GBorrelli.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

OK, do the Words "Start Location" exist as a header or is it the actual location name?

Does an empty row/column actually exist between records?

Are the records of data an Excel Table?