Sheet Selection and Data Filling

Hi All,

I have a worksheet which contains many worksheets: One for the Monthly Productivity Data of the team and rest of the worksheets contain individual employees data personally.
For Example: We have a dashboard which has all the employees performance Monthly Productivity Data, and if we move to any one of the employees worksheet; that shows his personal data/ score with ranking in each category of their group.

Note: We have divided our team in the 3 groups: 1 for most experienced, 2 for middle and the 3rd group for the new employees or less experienced.

This is how we would like to rank them in only their group of each category. I need your help to automatically present the data from Monthly Productivity Data to each individuals worksheet, where i can give him/her feedback(s). Number of employees is not fix in every month.

Could you please help me out to automate my this monthly work? Please find the attached for the same.

Thanks in advance!