Identify data in monthly sheets in WB and consolidate into master sheet

I have an application that will generate a report each month and export it to Excel. The problem is that there are no options to change the layout of the export and I need to get some of the information into a different format to be reviewed by the "higher-ups". The exported data each month will go to a new worksheet (but in the same workbook) and each month's sheet will have over 2,000 rows, so the idea of manually transferring this information is overwhelming (and for all practical purposes, impossible).

I've attached a workbook. I'd really appreciate any help you can give me.

Edited to include cross posted link:
http://www.ozgrid.com/forum/showthread.php?t=167864