Data ‘Duplication’ from one Tab into another Tab?

I have been developing a Workbook specifically to appoint referees and coaches to footy games in major tournaments.
I am trying to “duplicate” referee and coach appointments data from one tab to another – but into specific cells.
I have not been able to figure out a formula to post the field number and colour against the correct
Referee name.

The attached WorkBook contains examples and explains more.
I am grateful for assistance to date from many web sites and individuals who have greater expertise than I will ever have. So thankyou.