Pulling information from a source sheet

I would never claim to be an excel expert, so this might be a simple solution, but I need to pull information from a source sheet to create a table on another sheet.
Essentially, I need to pull certain info from the main sheet (“Pursuits”) into another sheet, and I need it to be dynamic.
I need to pull Columns B, E, F, J, L, M, Q, Y, Z, AC, AD, and AF into a new table, but only if the Status Column (Column H) says: “In progress” AND there is a date in Column Y and/or Column AC.

I am not sure how to pull this off.

You can put this formula in A7 of your Pursuits sheet (widen the column a bit first, then reset it afterwards):

=IF(AND(H7="In Progress",OR(Y7<>"",AC7<>"")),MAX(A$6:A6)+1,"")

and then copy it down to beyond the bottom of your data. It will give you a simple sequence (1, 2, 3, etc) for those records which meet your criteria. Then in your other sheet you can use a MATCH formula to find the rows where that sequence occurs, eg this in A2:

=IFERROR(MATCH(ROWS(A$1:A1),Pursuits!A:A,0),"")

and then use an INDEX formula to retrieve the relevant data, i.e. put this in B2:

=IF($A2="","",IF(INDEX(Pursuits!B:B,$A2)="","",INDEX(Pursuits!B:B,$A2)))

This can then be copied across, but you will need to manually change the columns to E, F, J etc. and maybe change the format (eg for dates). Then finally you can copy row 2 down as far as you need to.

Hope this helps.

Pete