using selected data within a dropdown list to populate new list
 

I have a pivot table list of chemicals compiled from various sheets of data.

I would like to select certain chemicals from the list so that they pupulate
a new list that is linked to another part of the sheet. The abbreviated list
is to be linked to a specially formatted page that can be used to print data
on just the selected chemicals.

ideally I would like to have a check box next to each chemical in the parent
pivot table so that when checked, the selected chemical appears in the
abbreviated list.

Can anybody help?