Nine box grid Problem

[HRDan88]

So, I have a nine box grid for a talent management colleague. They have a mirror of this on a separate sheet, the 9 box itself has a countif formula which pulls from objective data. I want to input a formula in all boxes in the mirror to return the name of the person which is inputted at the top of sheet 1 in the corresponding grid box in relation to highest number in the original 9 box on sheet 1. That may be horrendously convoluted haha!
Thanks in advance

 

[Yongle]

Perhaps this will help you to help others wanting to help you