Using Query for a selection of items
 

I use Excel a lot to extract data from our main system. Normally this is not
a problem. However we now have a series of contract that have specific
products on them and I need to report on sales per each contract.

The problem is that there is nothing to connect the items, so I need to use
the Or statement in the Query. Unfortunately our contracts have more that
the limited 8 Or statements allowed in a Query.

Is there a way around this? I thought possibly a named range that the query
could lookup with a list of products.