Trying to extract rows of info based on 2 or 3 conditions & paste to other sheet

I have a report that I get each week that has a project number, address, type of project (there are 3 kinds), it's status and it's project manager's name. It's never in the same order or has the same number of rows.

I want to go to the next sheet in the same workbook and add a formula that will extract from the main spreadsheet only one person's projects and only one kind of project, then have it paste the entire row w/ all the other data.

Hope that makes sense.

I thougth a pivot table would work but it doesn't and I've tried Vlookup but I don't think I know what I'm doing.

Thanks for any help. I've attached a sample database. I use Excel 2007.
Shannon