Search a column value and return results to summary sheet while highlighting duplicate val

Greetings all,

I have attached a spread sheet with 5 tabs, a summary tab (this is the result I wish to programmatically achieve)and some country code tabs which is my source data.

The Summary tab has been achieved by looking in column B and then returning the result in column C, with column A becoming my column headers and column B my row headers.

The part I have an issues with is some "levels" have more then one employee and don't know how to programmatically managed that, additionally I would like to highlight duplicates for each level is possible. I don't wish to eliminate duplicates simply need to highlight them.

Any help much appreciated.

Thanks' in advance
Ettiene