Repeatable offset based on inputs

I am trying to pull inputs from several tables in a certain order based on the inputs selected on a worksheet. For instance, if option 1 is selected then I need questions from table 1, 2, 3 and 4 to be listed in order. If option 2 is selected, I need questions from table 2, 4, 3, 1 to be listed in order. I have gotten my formula to work for pulling the first set of questions but I cannot figure out how to get it to move to the next table and start from the top of the next table. Is there a way to get excel to look at the first row of a new table when it has reached the bottom of another table?

I have used row(offset(Questions!$A$1,1,0)) and can get the formula to pull the first line from the next table but it is static after that
(so it goes Table 1 - Question 3, Question 4; Table 2 - Question 1, Question 1, etc. instead of T1 - Q3, Q4 T2 - Q1, Q2...)

Any thoughts?

Here is my sample data. I have defined a few of the formulas in name manager to assist with the writing and reading of formulas. Any help you can lend would be appreciated.

Example Form.xlsx

GLENN!! I owe you a pint, my friend. This is brilliant! I plugged it in my file and it works great. It looks like if the tables are different sizes I might have to deal with some blank space, but that is OK...it will actually make the next part a little easier to do. As you can see I've been pretty deep into building these formulas and this was something that I just couldn't wrap my brain around. Thank you so much!

GLENN!! I owe you a pint, my friend. This is brilliant! I plugged it in my file and it works great. It looks like if the tables are different sizes I might have to deal with some blank space, but that is OK...it will actually make the next part a little easier to do. As you can see I've been pretty deep into building these formulas and this was something that I just couldn't wrap my brain around. Thank you so much!