Copy from one Excel spreadsheet to another based on criteria

[gusgus86]

I have a spreadsheet that lists employee data from our Payroll software. One column lists the employees name and other columns list hour and wage information. I need to be able to copy and paste certain employees rows to a new spreadsheet where calculations are made adding wage and hour data and then multiplying some of that data by a multiplier. The problem is that some employees on this list do not need to be copied to the new spreadsheet. How can I set these employees to not be copied to the new spreadsheet. Also the employees in the spreadsheet can change from week to week.