Showing the whole row when matched

Try

in A2

Formula:

=IFERROR(INDEX(Sheet1!$A$2:$E$6,AGGREGATE(15,6,(ROW(Sheet1!$A$2:$A$6)-ROW($A$2)+1)/(Sheet1!$D$2:$D$6="Open")/((Sheet1!$E$2:$E$6="High")+(Sheet1!$E$2:$E$6="Critical")),ROWS($1:1)),COLUMN(A1)),"")

Copy across and down