I have a 3 pivot tables with information for 3 different areas.

I am trying to create something that will show what is needed for an individual site, based on infromation from one of the 3 pivot tables.
For instance if the pivot table for site A show that there are 4 data types for this site, the new table will show what is needed for this data.

so if site A has data types A, B, D, E
The table will show that it needs data groups AA, AB, BD, CE (data group names not linked to data type names)

Does this make sense?
Using office 2003