Assign Radio Buttons in Excel User Form to a Group at Runtime

The reason I requested a workbook was to be able to see the solution worked in-situ, however a year or two back I produced something similar that was expandable at run-time.
It is based on block modules of ten questions, to expand the questionnaire form simply add another block of questions to the sheet/table by inserting above the summation row.
Press the button and a second page is added to the multipage (it became an exercise in maths/algebra rather than coding) - this approach may be of some relevance to what you are trying to achieve.