Summarise multiple sheets with checkboxes

[Kazstankgardner]

Hi All,

I need to put together a vba code, which is way too advanced for my limited vba experience.

Basically.....I have an excel workbook with multiple worksheets in it. The majority of the worksheets are the same and include a variety of checkboxes and dropdowns(form controls). (The sheets were set up this way to ensure ease of use for the end user). I need to summarise all of the active sheets, into one easy to read summary sheet.

I have attached an example of the workbook for your information. Please help......

Thanks