Formula for returning multiple returns

Dear Forum.

Hoping someone can help me out with this.

I’m looking for a formula that will produce values associated with another cell’s value.

In the sample workbook on sheet 1 there is entry in G17:R25. On sheet 2 I want to have formulas in G10:P10 and/or in G15:G31 that will report the correct information from sheet 1 (I’m hoping this will make sense when you see it as it’s a little difficult to describe). I have manually put in the returns that I’d be expecting. I have highlighted G10:P10 & G15:31 as ideally I could have a formula for each way as I am not sure of the final layout in the actual real world workbook yet.
If this needs an Array formula that is fine but if it can be done otherwise, that would be preferable.
Assistance is very much appreciated.

You are a star benishiryo!! Thank you very much. This will make a sweet addition to the actual workbook .

To Admin/Moderator - When I try to go back into my original post to mark as solved for some reason my original text is gone. If I just try to mark as solved I get an error message saying that there needs to be at least 10 characters. I don't want to overwrite the existing by putting text in. Please advise if you require anything from me in this regards. Thank you!