Calendar creation from dates on various Worksheets

I'm a new user here helping out a relative with a project he has been wanting to complete for a while now. I used to be a computer repair tech, meaning everyone I know assumes I can do anything on a computer, even though I really only dealt with hardware repair and installation.

What I am looking to do is have a calendar on a worksheet that populates with dates from multiple worksheets across the workbook. I've got approximately 15 worksheets to pull dates from. Within each worksheet I have a table with 5-10 check options (Form control check boxes). When an option is checked, several dates appear going across the rows on the table. The dates in each row have several date ranges. For example, if I check option 1, I will get 4 separate date ranges of varying amounts of time. I would like these date ranges to then populate on the calendar. All worksheets should populate the same calendar. As each worksheet may have similar options, I would like the listing on the calendar to state Worksheet Name - Option Name for it's entry onto the calendar.

I've looked at the design of the calendar provided by Pete_UK and it looks like something that would work for me.

I am not sure as to what would be the simplest method to achieve this goal. Any help would be greatly appreciated.

I've included a condensed version of the spreadsheet I am working on as well as the calendar created by Pete_UK.

Thank you.

Any help at all would be great. Thanks.

Bueller? Bueller?

I've only just seen this (yes, I know it was started in October last year !!)

Are you still looking for a solution?

Pete