Trying to display results after comparing 2 cells on different sheets

Good morning,
I have been banging my head against the wall trying to figure out this one. Any help would be great.

I have an Excel 2013 workbook with multiple sheets in it. There is a MASTER page and multiple subordinate pages. This workbook is used to calculate employee commission and in turn place all the data on one sheet so it can be turned into the accountant. I have tried using VLOOKUP as well as 4 or 5 other options. None have produced what I am trying to achieve. Perhaps I am wanting something not possible. Here is a screen shot of the 2 pages. Below I will outline how they work and what I need.
Master.jpgSubordinate.jpg

Each employee will have their own sheet that will track their sales and the commission they get. On the sheet I only have 4 areas that are not locked, those are depicted with green cells. So the boss only needs to type the info in and it will calculate. This sheet is functioning fine.

On the master I have created a Data Validation drop down box to pull the payroll dates from the second sheet in column B. This is set as Check_Date

I am trying to select the check date from the drop down and have the data from the subordinate sheet pulled into the master. The only 2 pieces I need are PAYABLE and CASH TIPS. The number would come from the row that corresponds to the date in the drop down. This info needs to be pulled from each sheet that corresponds to a user on the master page

I am not sure if I need to add an index column to make this work or what.

Any help or suggestions are very much appreciated.

VLOOKUP should work. Use the date in the Master sheet to look through the table for Zarko and get the cash to be paid. Do that for each person.

Note - attaching a spreadsheet is much friendlier than pictures. With pics we can't test our ideas (unless we recreate your data). Also, if your sheets are set up a certain way, you could make the VLOOKUP use the person's name so you have a more universal formula, but I don't know your sheet structure.