What I would suggest you do (for sake of simplicity) is modify your RANK values, eg:

E5: =IF(D5=0,"",IF(RANK(D5,D:D,1)>10,"",RANK(D5,D:D,1)+ROW(D5)/10000))
copied down
(then copied to Col G, I)

This means each RANK value becomes unique by virtue of the decimal remainder which is the ROW number / 10000

With the above in place the resulting tables are pretty straightforward, eg:

Q17: =INDEX(B$5:B$230,MATCH(LARGE($E$5:$E$230,ROWS(Q$17:Q17)),$E$5:$E$230,0))
copied across matrix Q17:S26

the above table logic can be replicated in the other tables though you will need to adjust reference to Col E (to G, I respectively) and also references to Q$17 (to Q$30 and Q$44 respectively)