Return Values from Spreadsheet based on 2 criteria

I have a workbook with a data tab, lookup tab, and goal tab. Based on the values in cell D2 on the lookup sheet, I’d like to return “Goal 1”, “Goal 2”, etc to match the number from D2 and return these values beginning in cell A4. Secondly, I want to return the values in the data table starting with the first letter in cell E2 (F) and count over the same number of columns as in D2 and return those values as well beginning in cell B4. The goal sheet shows what I’m trying to accomplish if I’ve not been clear. Thanks for your time.

A little background might help, I suppose. I am hoping to build a solution that therapists can use to track data for special education students. I want it to be as automated as possible because they are busy with large caseloads. As odd as the layout is, I can't really control it because the data is populated by entries on a branched Google form. The form consists of a common section, a hidden section, and one section of questions (goals) for each student. In the associated spreadsheet, each question is a column header. I use the Google Query function to break out the data into separate worksheets for each student. It is these worksheets that I am looking for help with. Because the student goals can be very long, I list the full goal above the form responses and replace them in the breakout dataset with "Goal 1", "Goal 2", etc using the label argument in the query function. I am attaching the associated workbook from the Google form. In the workbook, there is a sheet for Wilma R._finished that shows what I'd like the worksheet to look like with minimal input from the therapists. Ideally, they'd only need to input data into cells A2, C2, D2, E2, F2 on the duplicated template. If you have the time to input some data into the form for Wilma Rios and look at the spreadsheet to work out a solution, I'd appreciate it.

I was able to successfully produce the result that I want using a little trial and error. For a student with 3 goals, I placed this formula in cell A4:
=transpose(query('Form Responses 1'!$A$1:$MZ$1,"select " & MID($E$2&"",1,10)& " label " & MID(E2&" ",1,2) & " 'Goal 1', " & MID(E2&" ",5,2) & " 'Goal 2'," & MID(E2&" ",9,2) & " 'Goal 3'"))

It gives me the text Goal 1, Goal 2, and Goal3 in cells A4, A5, A6 respectively. It also gives the full text of each goal in cells B4, B5, and B6.