Finding a sum from multi-sheets for a drop down list value

What I am trying to create
I am looking to create a workbook that spreads for 52 weeks. A sheet, week, will consist of a user defined drop down list of 50 "employee name". Horizontally across the page the "employee name" can have between 1 - 13 "X's". Vertically the sheet separates into "days of the week" and can possibly have the same "employee name" under each day, MTWTFSS. On a master sheet a sum of all "X's" specifically assigned to "employee name" from all 52 sheets is recorded.

Why I am trying to use Drop Down List
I attempting to create a yearly tracker for specific behaviors of all employees. I want to avoid having each employee listed under each day through out the week. It would not be convenient to have a 350 lines sheet to cover a week. (50 Emp x 7 Days).

What I have tried
I have less than a few hours of experience with Excel but am a avid learner and eager to become more competent in Excel. The functions I currently have tried using range from COUNTIFS and SUMIFS. Currently, I am unable to get this function to work. The error received is #value!

 =COUNTIFS('Sheet1'!A5,A1,'Sheet1'!D5:S5,"x")

I use ctrl + shift / enter for formulas.

This function is on Sheet2!A2 "master" where Sheet2!A1 is the first option in my "employee name" drop down list.
Sheet1!A5 consist of the first "employee name" selected to have "X's" ranging from Sheet1!D5:S5
Sheet1!A5 should equal Sheet2!A1 for sum to happen on master @ Sheet2!A2

After searching I believe the problem comes in with blank entries and probably some sort of text type. I have no idea.

Predictable Problems
I know this function will not work as I do not know a way of conveniently summing the possibility of the "employee name" showing up under multiple days of a single sheet "week".

Thank you for taking the time to view.
Steven L.

I am creating a sample workbook ATM; and will edit with an attachment in a few minutes.
- In my sample I forgot to note "X's" under behaviors for employees. Imagine next to each employee there is an X allocated to a specific behavior.