pulling info from other worksheets to a totals worksheet

[ardnas]

I have a workbook with a worksheet for each salesperson. I need to run at the end or each month a total of all sales for each salesperson on one sheet. So basically, if Column B in all worksheets is greater than 6/30/2011 i want it to pull the entire row of information into i.e, 26,27,28 into the total page.

I know this is conditional formatting formula but i am drawing a blank