Conditional Compiling to a New Workbook

[Athrial]

Ok, so I have a spreadsheet with basic invoice information that calculates profits, when we are paid, etc. One of it's features is to calculate a commission for an employee dubbed "Roy" if he is the salesman (under the column "SP" he's marked with an "R"). Once we have been paid by our customers Roy is ready to be paid and his columns are highlighted in red as an indicator.

What I would like to do is make another workbook that pulls only these paid Roy invoices (that whole row) that Roy should be paid for and compile them into a spreadsheet. This would be done every two weeks on a new sheet in this new workbook.

Thanks!