Sum Based of names - vba code save as pdf specific range

[chrismil]

Good evening, in a previous post, I was helped, now I need more help, because I have divided the names of employees into a category, and someone has the possibility to put him in another category, and I proceed to the questions below.

1) Employees 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 do 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 one.
Is it possible that the three name definitions I have made with the offset, are united in one instead of three separate, and in each category in the data sheets to be united ??????
In the data sheet2 I intentionally changed the names from a different category for the next step I will ask.

3) In the total sheet, I have three categories, if the three name definitions are made into one, I will adapt it to the drop-down lists,
When I choose an employee, is there a case for the calculation to be made based on the name, regardless of which category I have him in sheets 1,2,3 ??????
I also put a button if you can save the area D5: AK12 in the same folder where you find the file with the name you write in cell D5 and the current date.

4) And finally in the Report based on Name sheet to calculate in which category you are, and in which data you are.