try these three non array formulas...
for status...=IFERROR(INDEX(Enter!$D$2:$D$34,AGGREGATE(15,6,ROW(Enter!$A$1:$A$34)/(Enter!$D$2:$D$34=Here!$B$1),ROWS($A$1:A1)),COLUMN()-(COLUMN()-1),1),"")
for names... =IFERROR(INDEX(Enter!$B$2:$B$34,AGGREGATE(15,6,ROW(Enter!$A$1:$A$34)/(Enter!$D$2:$D$34=Here!$B$1),ROWS($A$1:A1)),COLUMN()-(COLUMN()-1),1),"")
for sales #... =IFERROR(INDEX(Enter!$E$2:$E$34,AGGREGATE(15,6,ROW(Enter!$A$1:$A$34)/(Enter!$D$2:$D$34=Here!$B$1),ROWS($A$1:A1)),COLUMN()-(COLUMN()-1),1),"")