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 each of 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.

I would like the default position to be that with all the check boxes ticked
so I can deselect just those chemicals i am not interested in printing

Can anybody help?