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.