Each page in your workbook has sub-section headings.
Is it necessary for these section headings to also be included on the summary page or do you just want the single line with the product info.

Just the line of info is easy.

I'm certain there's some wiz on this board that could accomplish pulling in the section headings, but for me it would require a serious overhaul of the layout on your current spreadsheets & helper columns.