In cell A3 of the Order sheet array-enter this formula.
Formula:
=IFERROR(INDEX(List!$A$2:$E$8,SMALL(IF((List!$E$2:$E$8>0)*(List!$E$2:$E$8<>"")*(--RIGHT($A$1,1)=List!$D$2:$D$8),rwCnt),ROWS($1:1)),COLUMNS($A:A)),"")
in A10 and A17 these.
Formula:
=IFERROR(INDEX(List!$A$2:$E$8,SMALL(IF((List!$E$2:$E$8>0)*(List!$E$2:$E$8<>"")*(--RIGHT($A$8,1)=List!$D$2:$D$8),rwCnt),ROWS($1:1)),COLUMNS($A:A)),"")
and
Formula:
=IFERROR(INDEX(List!$A$2:$E$8,SMALL(IF((List!$E$2:$E$8>0)*(List!$E$2:$E$8<>"")*(--RIGHT($A$15,1)=List!$D$2:$D$8),rwCnt),ROWS($1:1)),COLUMNS($A:A)),"")
Array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
The re-worked workbook is attached.
Bookmarks