I have the following pivot table:
Week              Delivery                Space            Utilization
Week1              42.3                      200.4            21.1%
Week2               24.5                      50.3             48.7%

I have a sheet in my workbook as a named range.  Another sheet has rows of
data with about 20 columns of information for each entity.  I want another
spreadsheet to pull only those rows if one column matches a value in the
named range.

In column A there is a list of dates.
In columns B-E there are four types of assignments ( I, II, III, IV).
In columns F-I there are list of persons available for each assignment
(some persons can do more assignments but not on the same day).