Hello cdc
Try pasting the following into cell C4 then dragging the fill handle over to cell BL4 and then, while C4:BL4 are still selected, down to cell BL7:
Formula: copy to clipboard 
=IFERROR(LEFT(INDEX(Input!$C$2:$C$4,AGGREGATE(15,6,(ROW($C$2:$C$4)-ROW($C$1))/(Input!$E$2:$E$4=C$2)/(Input!$A$2:$A$4=$A4),1)),3),"")

Let us know if you have any questions.