Dynamically fill the table

[Bluya]

Hello Everyone,

I would like to fill my other sheets related to the Dashboard excel sheet. In the dashboard excel sheet, I collect the names, surnames, and ages of the person and which clusters they are in. In the future, I will continue to add it and it will be a very big information sheet. For example, I would like to do if one person only includes in cluster A, their name, surname, and age directly appears in the excel sheet A, dynamically also same as the other clusters. But the important part is only they belong to the one cluster. For example,

Sophia belongs to cluster A only so her name, surname, and her age directly have to appear in the excel sheet A.
BUT
Jacob belongs to all three clusters (A, B, C) so we do not need to take his information to one of the clusters excel sheets.
AND
This rule is valid for all clusters.

Thank you in advance. If you have any questions, do not hesitate to ask me.

[JeteMc]

This proposal employs a helper column (H) on the Dashboard sheet.
The helper column may be moved and/or hidden for aesthetic purposes and is populated using: =IF(COUNTA(D3:G3)<>1,"",INDEX(D$2:G$2,MATCH("x",D3:G3,0)))
On each of the cluster sheets cell E1 is populated with the sheet name.
The formula that populates the cluster sheets is: =IFERROR(INDEX(DASHBOARD!A$3:A$9,AGGREGATE(15,6,(ROW(A$3:A$9)-ROW(A$2))/(DASHBOARD!$H$3:$H$9=$E$1),ROWS($A$1:$A1))),"")
Let us know if you have any questions.