Hi, again...
Try this formulas:
[B6] : =IFERROR(INDEX(Planilha1!$B$3:$B$34,AGGREGATE(15,6,ROW(Planilha1!$B$3:$B$34)-ROW(Planilha1!$B$2)/(TEXT(Planilha1!$D$3:$J$34,"[$-416]mmmmyyy")=$C$2&$C$3)/(Planilha1!$F$3:$L$34="Aberto"),ROWS(B$6:B6))),"") --> Drag it down.
[C6] : =IF($B6="","",INDIRECT("Planilha1!"&TEXT(AGGREGATE(15,6,(ROW(Planilha1!D$3:J$34)/1%+COLUMN(Planilha1!D$3:J$34))/(TEXT(Planilha1!$D$3:$J$34,"[$-416]mmmmyyy")=$C$2&$C$3)/(Planilha1!$F$3:$L$34="Aberto"),ROWS(B$6:B6)),LEFT(ADDRESS(,1,4,0))&"0C00"),)) --> Drag it down and right.
Check file. Blessings!