Macros: To Add more members in a Excel Questionary CFrom

Hey guys! Thanks for this space! For work, I need to create an Excel Form for family groups, each person must answer each question, I would like you to please help me with three things: (I don't know if it is possible to do it)

1. A button to add members, that is, in each question insert cells, which brings the member's name in each corresponding row. (Maximum 12 Members) Bring the name from the top of the form of the added member to every row that needs it.
2. I need to add another button, allowing each question to be answered with all NO or all YES for quicker completion.
3. I don't know if you can block the opposite response button, that is, if the answer is no, block the click so that the Yes cannot be answered

I have attached an example of the form that I need to create.

Thanks!

Hi and welcome

Does the form absolutely have to be in this format?
You could use a UserForm for this and managing things like adding family members and restricting responses would be a whole lot easier.

BSB