I have a multisheet work book. One of the sheets I want to be a summary page. I'm looking for an equation that will look at all the sheets for one term, if the term is found, I want it to put the corresponding row of information on the summary sheet.

Ex:
Sheet 1
Delete Joe 5 $15
Jane 6 $12

Sheet 2
Amy 2 $38
Delete Josh 4 $3
Kim 6 $2

I want the summary sheet to show only:
Delete Joe 5 $15
Delete Josh 4 $3

Note: Each word/number is in it's own cell.

Is this possible?