Concatenate values from reference sheets

hello everyone. I have a different sheets connected each other with references. I need to bring some values from some columns in reference sheets to one cell in main sheet in every row. I Concatenate(), but its brings all column volues ensted of rows conected with ID

0 6 532
6 REPLIES 6
Top Labels in this Space