What formula is recommended to return the contents of a column when the header is selected

I am working on an online course and setting up a template for a client to use to set up a Quiz. I would like to use excel in the following way:

When a question type (A1, B1, C1 or D1) are selected, the entire contents of that selected column will show in the template so that the client knows what is required for that type of question.

In 1 quiz there could be up to 10 - 40+ questions using the various options of question types.

My questions are

Is it possible to use excel as follows: when A1 is selected, A2 - A10 will show in the excel template for the client to then fill in the required information?
What formula would be used to do this?
How could I set it up so that the required number of spaces below each question will then be made available according to the type of question selected? Followed by the next question option.

Many thanks for your help with this.

Oh my goodness that is so clever and so quick. I will try and copy and paste your formula as I am definitely out of my depth here Thank you so much for your help!

Thank you thank you thank you! I really appreciate your help! I will give this a try and mark it as solved as soon as I get it working. Thanks once again!!!

Apologies - as I mentioned I am way out of my depth and this is a lot like Greek to me. I am missing the link between defining the name and the data validation. When the client selects the first option (A1), I would then like that column content to appear below as you made it do so. If they select the 2nd option, it will be 2nd column contents that will need to appear.
I've defined the name, done the data validation and get the row 1 options but not the content below each. I would greatly appreciate further help with this.
Many thanks!
Claire

That is amazing!!! Thank you so much for your help and time. You have saved me days of struggling with this and I will continue to play around with this from here!!!

Hi Oeldere
If you have any time or patience left I have just 1 last question. I copied your formula and added further data validation fields for the next questions and copied your formula down the column where appropriate. Although the formula is there and the data validation is working it still doesn't populate the fields below. How do I make the formula do what it should do.

I am working on an excel course after hours to get up to speed but I sure wish I had your knowledge in my head already.

Many thanks once again.

Claire

Screenshot of B17 cell showing formula.jpg

In the screen shot you can see that I have copied and pasted your formula in B17 from B4. The spaces are to ensure there is enough space for the list that will populate as I need about 40 of these questions per quiz.
I think you are laughing right now

Ok getting there. That does populate the fields below but not with the correct information. Whatever happens in the first question is what populates for the next question. If you change the question option in the 2nd question it doesn't change the fields below.

Perfect perfect perfect!! Thank you once again. I am so blown away by people like you who are happy to help and it saves so much frustration and teaches me so much when I am struggling. Thank you - you have just been incredible!!!
Have a lovely evening!
Kind regards
Claire