Let's back up a second. I don't get why you need individual tables, Profile 1, profile 2, etc.
Why not put all that in one table, but label the responses with an extra field where "profile 1", "Profile 2" or some such identifier can be used to group the responses by profile?
This sounds like a survey database. If so, there are a number of older discussions about surveys that you can pull up by entering "survey" in the search the forum field at the top of your screen.
Generally, you'd have at least 3 tables: Questions, Responses, Respondants and the responses table can use looked up values settings to copy the question text if needed.
You can specify a Format for your responses field by adding a format field in Questions with values that identify the response format (Check boxes, radio buttons, drop down lists...) and another field in this record can supply the valuelist for it. If you display one question at a time, you can have a different layout for each response format and simply select the correct layout as specified by the response format field.