Filling color of a cell (not as easy as sounds)

Hello,

Thanks to this forum, I was able to solve my previous issue with my excel file, and I am now stuck in the second and last task.

Basically, what I want to achieve is this:

If (Name) in Sheet 2 is Level (n) in Sheet 1, fill (Name) cell in Sheet 2 with corresponding color

As soon as Person's name is set in Sheet 1, it will pop up in Sheet 2 at corresponding shift, and I want it to have its designated color based on its Level.

A picture should save a thousand words...
12.PNG
13.PNG

Also, please find the attachment for excel file!

Thanks

Please try at A7:U26 1 formula for the whole table

=IFERROR(INDEX(Sheet1!$B:$B,AGGREGATE(15,6,ROW(Sheet1!$D$2:$H$51)/(LOOKUP("z",$A$3:A$3)&" "&LOOKUP("z",$A$4:A$4)=Sheet1!$D$2:$H$51)/(Sheet1!$I$2:$M$51=A$5),ROWS(A$7:A7))),"")

Conditional formatting applies to A7:U26

=IFERROR(INDEX(Sheet1!$C:$C,AGGREGATE(15,6,ROW(Sheet1!$D$2:$H$51)/(LOOKUP("z",$A$3:A$3)&" "&LOOKUP("z",$A$4:A$4)=Sheet1!$D$2:$H$51)/(Sheet1!$I$2:$M$51=A$5),ROWS(A$7:A7))),"")=1
fill color for level 1

=IFERROR(INDEX(Sheet1!$C:$C,AGGREGATE(15,6,ROW(Sheet1!$D$2:$H$51)/(LOOKUP("z",$A$3:A$3)&" "&LOOKUP("z",$A$4:A$4)=Sheet1!$D$2:$H$51)/(Sheet1!$I$2:$M$51=A$5),ROWS(A$7:A7))),"")=2
fill color for levle 2 and so on