clicking a single checkbox that will then click a specific group of checkboxes within sheet

If you name your controls smartly this can be done with a bit of VBA.

Name the checkboxes within a group cbx_1_1, cbx_1_2, cbx_1_3, cbx_1_4

Name each group checkbox: cbxGrp_1, cbxGrp_2, ...

Attach this macro to each group checkbox:

Sub cbxGrp_Click()
    Dim oCbx As CheckBox
    Dim lValue As Long
    Dim sGrp As String
    sGrp = Application.Caller
    lValue = ActiveSheet.CheckBoxes(sGrp).Value
    sGrp = Split(sGrp, "_")(1)
    For Each oCbx In ActiveSheet.CheckBoxes
        If oCbx.Name Like "cbx_" & sGrp & "_*" Then
            oCbx.Value = lValue
        End If
    Next
End Sub