Sum Based of employee names different categories, different sheets.

[chrismil]

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