Extracting Data Based on Yes or No Condition

One way is using Arrayed formulas (another way would be using 3 dummy columns)

In List1 sheet, A2 entered with CNTRL SHFT ENTER instead of a simple ENTER( you'll see {} around the formula if done properly)

=IFERROR(INDEX('Main List'!$A$2:$A$11,SMALL(IF('Main List'!$E$2:$E$11="Y",ROW($E$2:$E$11)-ROW($E$2)+1,5E+100),ROW(A1))),"")

Then in B2, you'd just need to change what you are Indexing
=IFERROR(INDEX('Main List'!$B$2:$B$11,SMALL(IF('Main List'!$E$2:$E$11="Y",ROW($E$2:$E$11)-ROW($E$2)+1,5E+100),ROW(A1))),"")
and so on.
I did List 1. Let me know if you have problems duplicating it.