Multiple Workbooks VBA code

So, let me explain my scenario...

I have 4 workbooks with employee's times listed for every day of the week. I have a master workbook that has worksheets that divide the employees up. Each worksheet in the master has a total of 6 potential jobs that could have been worked on (yes, per employee which is the worksheet).

I want to find a way to check the contents of each "workbook" and place in the corresponding master sheet's worksheets (or employees sheet).

The key field is:

Employee

That will allow me to test for this and copy/paste where applicable under the corresponding sheet in the master workbook.

Please if you have any advice or direction (samples, etc.) that would be greatly appreciated.

Mike H.