Sum Based of employee names different categories, different sheets.

Good evening.

1) Staff sheet:
I have divided them into three categories and in arrow 10 I show the example in case I change a category.

2) Sheet data 1,2,3
They contain the check that I will make during the week, that I will pass what information from a diary that I have made.
In the sheets in each category I have a drop-down list with a definition of each.
Is it possible that the three name definitions I made with the offset, are united in one instead of three separate, and in each category in the data sheets are united ??????
In the data sheet2 I intentionally changed the names from a different category for the next step I will ask.

3) In the whole sheet, I have three categories, if the three name definitions are done in one, I will adapt it to the drop-down lists,
When I select an employee, there is a case for the calculation based on the name, regardless of which category I have on sheets 1,2,3 ??????


4) And finally on the report sheet based on the name to calculate

Originally Posted by JeteMc

If I understand correctly:
1. Put the Categories and Names in a table as modeled on the Employees sheet
2. The OFFSET function in the Name Manager becomes: =OFFSET(employees!$B$12,MATCH("A",employees!$A$13:$A$27,0),0,COUNTIFS(employees!$A$13:$A$27,"A"))
3. The Data Validation drop downs still use the Named Ranges as sources
4. The formula for the Report sheet is: =IF(INDEX(employees!$A$13:$A$27,MATCH($D$5,employees!$B$13:$B$27,0))=RIGHT(C$6,1),INDEX(Data1!$D$5:$D$23,MATCH($D$5,Data1!$C$5:$C$23,0)),"")
Let us know if you have any questions.

thankyouououou