Index Match with Header and sub header

On Sheet 1 I have a table that has a beer name in merged cells D1:G1 as my header. In D2:G2 i have subheaders 50 L Produced, Loss, 50 L In Bright, 50 L Racked.

In Column C3:C15 I have Months December-December.

Sheet 1 Below

C D E F G
Cloud Ripper IPA
Month 50 L Produced Loss 50 L In Bright 50 L Racked
December 14.08 1.00 0.00 14.00
January 17.90 2.00 0.00 17.75
February 30.86 1.00 24.00 6.78
March 30.85 18.09 0.00 53.48
April 29.26 3.00 0.00 29.03
May 27.92 1.00 0.00 27.84
June 44.24 3.00 0.00 44.02
July 44.04 0.23 0.00 44.02
August 62.08 0.23 32.00 30.07
September 0.00 0.08 0.00 14.06
October 30.70 0.30 0.00 30.67
November 43.54 0.73 0.00 43.48
December 0.00 0.00 0.00 0.00

On Sheet 2 below I have a report i’m trying to run that willl search for Cloud Ripper IPA&50 L Produced, then return the intersecting cell with the month october.

A B C D E
Biff and Griff Dry Hop Wit Bull Run Imperial Stout Cloud Ripper IPA
October 50 L Produced 0 0 30.70
October Loss 0 0 0.30
October 50 L In Bright 0 0 0
October 50 L Racked 0 0 30.67

I have used the following formula and date and receive the #ref error. It should return 30.70

=INDEX(Sheet1!D3:G15,MATCH(E1&B2,Sheet1!D1:G1&Sheet1!D2:G2,0),MATCH(A2,Sheet1!C3:C15,0))

Maybe attach the file?

The sheet discrepancy is where i am trying to get the results from the sheet production.

So for example, from the sheet production, i want to pull 50 L racked for september into the sheet discrepancy under racked for
september for each particular beer.

As you can see i have a formula that pulls it over, but it doesn't look at the month. So i can't just copy it down for each month,
i have to change the formula every month and for each entry which ends up being quite time consuming.

Destroyed/Loss also pulls from loss on the production sheet. Ending inventory pulls from keg and bright inventory.
Sold pulls from a different sheet i had to delete to make this fit. Hopefully this explains what i'm looking for. Thanks for your help.