Loop or Advance Filter -VBA - Separate values into workbooks

Hi,

I know this is a very common request, but I must be typing the wrong keywords into EE Search and  Google.

I have a list (table) of several hundred people and the hours they have worked (each date is one row). Each line has their employee number, name and hours worked (along with other fields). What I am trying to do is create a new workbook for each employee that list all the dates/hours they worked. This way, I can email them their own workbook without sending the master list to everyone.

I have looked for loops and advance filter VBA solutions to get me going, but most of them are created to make a list of the unique value out of the table.

Any links for help is greatly appreciated.

Thanks, Brent