How to Click on one Checkbox that clicks all Checkboxes VBA

I want to be able to Click on one Checkbox on Excel VBA that is able to Click on 5 other Checkbox's. My scenario is I want to create a table that shows 5 types of Data, what I want to accomplish is to create a Checkbox that clicks all of these other checkbox's, and therefore loads all data without the user having to check all 5 of these other Checkbox's. I want this checkbox to also be ticked if the user has ticked all 5 other options, and when the user has clicked then unclicked this Checkbox, for all the options to unselect itself. Hope someone can help?