Making a value sensitive summary page for quoting materials

I have a workbook with 10 pages, and users can choose from around 30 different "blocks", using several different ones on each page. I need to be able to create a summary page that only show the blocks used, and their totals from all pages. I currently have an unwieldy table that pulls values from each page and lists all blocks that can be used, then sums them and outputs this to a chart again listing every block. Excel is constantly showing the table as errors, and occasionally the page references will get messed up, even when I hardly use the summary page myself. The salesmen use it to generate quotes. I just need some direction, or even a process to get the values generated on each individual page to the summary page. It would be nice to have only the items we need listed on the estimate.

Hello,

I also have a case somewhat like yours. I have copied all 'blocks' to one summary sheet. Then naming blocks with characters A,B,C,.... in one column. Characters of course must be on every row of the summary page.
Then I made a code that hides or unhides the entire row based on wich character is in the column.

-Sooperi