Excel Relationship linking Macro

Hi Experts,

I am looking for help which allows me to select cells and link them basis of field i would configure, or group them together.

1. When i click on the any cells of these group the the whole link should change color indicating me that they are linked to a group

2. When i click on the selected field, it should list all the names in the and print them.

The example is attached in the spread sheet.
Note: Please make it in general so that i can apply to my area of work.

Thanks in Advance.
Nandu