Consolidate Data

Adjust these formulas as required, insert sheet name when referring to ranges etc
To be honest your spreadsheet should really reflect your original layout even if its just a small amount of data.

I;m assuming data starts on row 3 cos thats what youve supplied as example data.
If not change ALL the 3s in the formulas to whatever row the data starts on

in A23
=IFERROR(INDEX($A$3:$J$8,AGGREGATE(15,6,ROW($A$3:$A$8)/(($G$3:$G$8="Y")),ROWS(A$3:A3))-(3-1),1),"")

in B23
=IFERROR(INDEX($A$3:$J$8,AGGREGATE(15,6,ROW($A$3:$A$8)/(($G$3:$G$8="Y")),ROWS(A$3:A3))-(3-1),COLUMN()+6),"")
copy across to D23

copy these formulas down as far as row 28

in A14
=IFERROR(INDEX($A$3:$J$8,AGGREGATE(15,6,ROW($A$3:$J$8)/(($D$3:$D$8<=TODAY()+60)*($D$3:$D$8<>"")),ROWS(A$3:A3))-(3-1),1),"")

in B14
=IFERROR(INDEX($A$3:$J$8,AGGREGATE(15,6,ROW($A$3:$J$8)/(($D$3:$D$8<=TODAY()+60)*($D$3:$D$8<>"")),ROWS(A$3:A3))-(3-1),4),"")

copy down as far as row 19

NOTE: Make sure you format the output grids correctly, e.g. dates and numbers