Returning values based on "if"?

[Sarah]

I have seven product lists in worksheets within a
workbook and I'd like to setup a product summary sheet
within the same workbook based on whether or not the
quantity column in the product listing sheet has a >0
value. Basically, the summary sheet will act as a pull
sheet to begin an installation job without having to list
all possible products - just those needed. It should
return the values associated with the >0 qty - such as
description, unit cost, and unit number which all appear
on the product listing on the same row as the qty. I've
tried lookups, pivot tables but I can't seem to get it to
work just right. Any help would be appreciated.

Thanks!