I has a similar need some time ago and I approached in a similar way, but with some “automation” in the middle.
Basically, there is a Questions table and a Users table.
The complete Questionnaire table is the union of the two with a Date, the Answer column and some other stuff you might find useful.
Anytime you add a new User, you just create the whole set of Questions for that user at once with a button.
Here a basic working example: let me know if it helps:
A better “detailed view” for the questionnaire is obviously a plus.
Cheers!