I've been going through past Qs without a solution

I have a spreadsheet with multiple columns and rows.
I need multiple criteria to be met (all true) and then have the whole row
extracted to a new worksheet, whilst ignoring blank entries. Below is an
example of the .xls.

Status Request Date M OR B Site PC 17" 19" 24" A4
OPEN 376929 11-Dec-07 M ORH
OPEN 404577 1-Feb-07 M RIC 5
CLOSED 439579 22-Mar-07 M LMA
CLOSED 448897 12-Apr-07 M ALB
CLOSED 457180 27-Apr-07 M RIC
OPEN 466290 14-May-07 B LMA
OPEN 466291 14-May-07 B LMA
CLOSED 466416 15-May-07 M ALB 3 3 1
CLOSED 469083 21-May-07 M RIC
OPEN 469596 21-May-07 M ORH 1 1
OPEN 470477 22-May-07 M ALB 1 1
OPEN 470583 23-May-07 M RIC
CLOSED 471075 23-May-07 M ORH