Retreiving Multiple Matches values in same row if "x" is true

this is a little complicated to describe, I have attached a workbook, that is colorcoded to help visualize what I am trying to do.

I have a "Sample" tab that shows the results I want, with no equations built in...I also have a DATA tab, with active equations....

I am sorting information from multiple worksheets into a "DATA" worksheet. I am trying to figure out a way to monitor production by "employee by zones worked" by taking a snapshot of 1 weeks worth of production numbers. With the help from multiple people on this site, I have been able to retreive all the information from a week, now I am seeking help into figuring out how I can sort this information by zones the employee worked.

I have included a Legend in cells D28:E32 so you can see what color each zone represents and how I want their production numbers sorted.

Most of the time, an employee will work in the same zone all week long; however from time to time with vacation time, or missed work, we have to move people to different zones. This is a challenge as each Zone has different production incentives relating to it. So it is imperative to figure out a way to track this production.

In cells A34:S56, I have a table with a collection of employees name, and the area that I would like the values from the above table (cells A1:Z26) to be inputted.

So as an example, based on the zone found in cell F6, it will place the production numbers for that day below in the correct Zone in row 36,(as the employees names are the same), then it will search the next day cell K6, and do the same thing, repeating this until it has returned all the production numbers for the week into the chart below. So you will see in cell F36 it is a combined Production total of everyday that Michael Winters worked in Zone 1.

Also note in cell D5, if you change the date it will change the information to pull the information from that date....

I am very aware, that I may not be able to do what I am trying to do as it is currently designed, and I feel I might be missing a step, so any guidance is appreciated.