Highlight multiple individual cells in a large workbook linked to a single cell on summary page

I'm working on a large price book database where we have multiple sheets pertaining to various parts of pool building such as excavation, steel, shotcreet, plumbing, etc.  I have a summary sheet wher...