IN A2 of register sheet then copied across up to column B.
=IFERROR(INDEX(All_Fem!A:A,AGGREGATE(15,6,ROW(All_Fem!$A$2:$A$200)/((COUNTIF(Register!$A$1:$A1,All_Fem!$A$2:$A$200)=0)*(COUNTIF(Data!$B$1:$B$10,All_Fem!$A$2:$A$200)>0)),1)),IFERROR(INDEX(All_Tib!A:A,AGGREGATE(15,6,ROW(All_Tib!$A$2:$A$200)/((COUNTIF(Register!$A$1:$A1,All_Tib!$A$2:$A$200)=0)*(COUNTIF(Data!$B$1:$B$10,All_Tib!$A$2:$A$200)>0)),1)),IFERROR(INDEX(All_Inl!A:A,AGGREGATE(15,6,ROW(All_Inl!$A$2:$A$200)/((COUNTIF(Register!$A$1:$A1,All_Inl!$A$2:$A$200)=0)*(COUNTIF(Data!$B$1:$B$10,All_Inl!$A$2:$A$200)>0)),1)),"")))
Bookmarks