Payroll workbooks for multiple locations

I am trying to create a workbook that will have the first worksheet as the parent document where all the necessary information would be added, This information can total approximately 300 lines every 5 days.;

1. Name
2. Locations
3. Hours worked (1st - end of month)

I need to find a formula that would search Column A (Name) for specific names and then pull all the information in that row and put it in a separate worksheet created for each specific person.