This:

=MAP($A$4:$A$100,$B$4:$B$100,LAMBDA(a,t,LET(_at,Targets!$A$2:$A$33&Targets!$B$2:$B$33,_p,XMATCH(a&$B$3,_at,,-1),_m,DROP(TAKE(Targets!$C$2:$E$33,_p),_p-SUM(--(_at=a&$B$3))),_Pts,INDEX(_m,,3),IFNA(INDEX(_Pts,XMATCH(10,SUMIF(t,INDEX(_m,,2)&INDEX(_m,,1),_Pts))),""))))