Macro to read specific questions, and provide answers

Hi all,
I trying to do something in excel which sounds simple but may not be simple, hence, here I am

I have user(s) who will use this excel template -> sheet 1 to copy and paste data from a website. Sheet 1 will contain nearly 700 to 900 lines, when copied from excel. User has to grab certain information to create a record in the system. In sheet 2 I have listed the questions user will be looking for. In the result tab, you can see the output I intend to get.

Sheet has many questions, and answers to that is underneath that question in the same column ( I wish I have questions in column A and answers in Column B - can this be done by Macro?)
If above is not possible, in sheet 2 , I have listed questions for which user needs to find an answer from sheet 1.

Sheet 1 is not always consistent. For example: answer to the questions an be 2 lines, 3 lines. That depends. In this case, for question 2 , I have 3 answers (EFGH, IJKL, MNO), but it can be 4 or 2 depending on each record in the website.

Is there a macro, that would help me achieve what I have in result tab?


Thanks,
MaryFlower