How to create Drop down with formula

[IammeResources]

Hey,
I'm a primary school teacher who has been diagnosed with severe heart failure.
As a result i have lots of time on my hands.
To want to give you an idea of what my goal was from excel: Maths Question Generator

So basically my goal was to create a word bank of questions for teachers to use that are focused on primary age children.
Tick, i done that. I created a page dedicated to each type of question (Well, i'm still adding new pages to it)

Then, i wanted to be able to retrieve just one question from a page of my choosing.
Tick, i done that, i created index formula with randbetween to select one question at random.

Now, I want to create a front page that has 4 separate drop down boxes. (Most maths lessons start with a 4 a day of arithmetic questions)
The drop down boxes need to be identical so i can select one question type from each.
After i select one question type from each list i would like them to appear in another cell beneath so it looks a little more aesthetic.

How would i go about this?
Thanks in advance

What i hope for it to look like below

 

[Fluff]

Duplicate to: Question Generator Headache.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.