Embedding index function in sumproduct

Here is a mockup spreadsheet of what I'm trying to do. Its comlpex but to me it seems like it should be doable on excel

Try

=SUMPRODUCT(--(Sheet2!A8:A12<Sheet3!A6), Sheet2!B8:B12,Sheet2!C8:C12,SUMIF( Sheet1!B1:F1,Sheet2!A8:A12,INDEX(Sheet1!B2:F6, MATCH(Sheet2!A1,Sheet1!A2:A6,0),0)))

that worked on the mockup ill see if i can get it to work on the real thing. Thanks so much this has been almost two days of work trying to get this.