Creating auto populating Summary sheet as new sheets are added to work book

I have a request to try to create an "Exceptions" summary sheet for a work book that is "designed" to have new sheets created for each 'instance' of a winter event throughout the winter season.
Before anyone suggests thathtis would be better to be created in a database, yes, I know, and a database was actually created and used for three years prio to this, but the managers felt for some reason that this was too complicated and limiting for their purposes, so they went ahead and created an Excel workbook instead.
The 'design' of the workbook is for the user to copy a template sheet to the end of the list of all the worksheets. The managers want to be able to generate a running report from these worksheets that shows a list of all trucks that have used more than the 'alotted' amount of material during the snow event.

I have included a sample of what the users want for their exceptions sheet, and a number of sample 'incident' sheets. I need to be able to check each sheet for any truck that has material usage over the allowed limit, then copy the date, foreman info, truck number and material amount to the summary sheet.

I have thought about trying an =indirect() formula,or perhaps a =vlookup formula, but I just don't know how to get them to work through a reference to multiple sheets...

The 1st sheet is supposed to essentially be a report based on the data being generated in the following sheets. The 'work flow' of the workbook is for the user to create NEW sheets as the year progresses (not add data to existing sheets), and the managers want to have the 1st sheet generate a report against all of the existing sheets and any new sheet that is created throught the winter. Essentially each of the sheets will represent a single winter day when there was an "event" that required the use of equipment and materials. The summary sheet is supposed to look at the daily sheet for any over usage and report that in summary with the date, the offending truck number, the amount that was actually used and the amount that was expected to be used. Then there are comment fields for justification of the overage.

The formula, macro or VBA script needs to be able to ennumerate all the sheets between the first and last shet in the "?data?" range of sheets and then create the report based on the information in those sheets. Doing a sum on single cells isn't that big of a deal, but making the whole thing actually step through each sheet inthe range, grab specific cells from that report and put the into the requested format is well beyond my capabilities.

Thak you for looking at this I'm pretty much stuck.

First, I want to explain that I did NOT create this to begin with, and that I am comming in to this in the middle. Unfortunately I am just as confused about WHY the workbook was created as it is as anyone else that looks at this. I am also putting in the FULL version of this workbook, as I am realizing that anyone foolish enough to try to help on this disaster will need to see the whole thing.

The 'workflow' that is supposed to heppen here is that stockpile foremen will record the truck data on a sheet that matches that is shown in the individual "stockpile" worksheets on the right had side of the tabs.
An office worker receives these either electronically, via fax or hard copy, then enters the data into the 'stockpile' sheets. The office worker copies the "master" worksheet to the end of the "date" sheets (between sheets named "." and ".."), THEN COPIES the cells in the 'stockpile sheets and pastes them into the new work book.

this workflow means that the data in the 'stockpile' sheets are ephemeral since the data on those sheets are changed each day that there is a winter event, so they cannot be used for the calculations.

What you will see is a number of "date" named sheets between sheets named "." and ".." The "dated" sheets are needed to be used as data sources for the "Exceptions" sheet.
Each "Event day" has 8 "stockpile areas" which are copied and pasted from the stockpile sheets.
The data fields that will need to be pulled for the report on the "Exceptions" sheet are:

• The date of the event (Found in cell B1of each sheet)
• The foreman number for the specific exception - this could be found in cells F101, Q101, F141, Q141, F179, Q179, F218, Q218, F258, Q258, F298, Q298, F337, Q337, F376, Q376
• The Shift (AM/PM) - this is recorded on the sheets in columns: A & L; rows: 105, 145, 183, 222, 262, 302, 341, 380
• The Stockpile Number Found in columns: A & L; Rows: 106, 146, 184, 223, 263, 303, 342, 381
• The Truck number that was over the exception limit: Columns A & L, Rows: 109:139; 149:155; 187:193; 226:236; 226:270; 306:314; 345:353; 384:394
• The Spread Rate from Column: G; Rows: 109:139; 149:155; 187:193; 226:236; 226:270; 306:314; 345:353; 384:394

So we are looking to have SOME sort of script, macro or array formula that will look at the sheets as they are created betwee sheets "." and "..", check the data in cells [where "sheetname" is the name of the sheets between the "." and the ".." sheets]
('Sheet name1:sheet nameX'!G109:G118,G121:G130,R109:R118,R121:R130,G149:G156,R149:R156,G187:G194,R187:R194,G226:G237,R226:R237,G266:G271,R266:R271,G306:G315,R306:R315,G345:G354,R345:R354,G384:G395,R384:R395) to see if the data in these cells are in excess of the allowed spread rate according to cells Exceptions!S3:T10. Each stockpile has it's own exception rate that all trucks assigned to that stockpile are checked against. Based on the check, we then copy the bulletted data above into the rows in the Exception worksheet.

Materials_Sandbox.xlsm

I am not sure if I have made this clearer or not (probably not...) but I appreaciate you even looking at this disaster for me.