#REF result using Index and multiple Match requirements

I am using 2 separate Index match formulas to pull data from 2 separate sheets if 3 cells match. It works fine on one sheet but I get a #REF error when trying to pull data from the 2nd sheet. I've copied examples from the 2 different data pages and put them on sheet 1 with the formulas in cells D8:G8 on sheet 2. For the #Ref errors, it will work if using only 1 match but not multiple matches.

The data comes from 2 different people and is formatted differently. I've tried formatting the same and still get the #ref error.

Thanks for any support.