Having one worksheet pull information from all the other worksheets

[Jenlynhow]

I have a workbook that houses the status reports of project components for a dozen or more worksheets. Even line in the table of the worksheet has a status of Pending, Approved, Rejected or Cancelled. My boss often asks me which line items are incomplete/pending. Is there a way for one worksheet to pull all of the line item detail from the other worksheets for all lines that contain "pending" in the status cell? It's far too time consuming to hand cut and paste the information and he prefers to work with paper rather than his computer, so just giving him the file to look at doesn't help me either. I have read many other posts regarding this subject, but they all seem to be dependent on numbers and mine is dependent on text.

[Pete_UK]

You would get faster responses if you attached a sample Excel workbook. The yellow banner at the top of the screen gives details of how to do this.

Hope this helps.

Pete