Custom payroll slip generator

[ASki]

I've made a custom payroll sheet that I'm attempting have populate for each employee from data in the other worksheets in the book.
I need to use vba or a macro to search for the master paysheets and only populate hours worked for days or run numbers that the specific employee worked. I think this may be a job for VLOOKUP, but I haven't found a successful way to make it work. I'm hoping the solution is just something simple that I'm getting, but any help would be appreciated. I'm attaching a copy of the payroll with some dummy data to help illustrate.