Formula to match data in different sheets ( multi column) and return matching values

Hi, i need some help to write a functions to perform a text matching and value extracting.

In Sheet 1:
column A is group name, column B is value matching A

In Sheet 2:
i have 3 column, ABC, where each column will have a group name within it. D is returning value

How can i write a functions that matches the text from cell A1 B1 C1 (Sheet 2)with column A(Sheet 1), if they found a match, return the value from column B (Sheet 1) into D1(Sheet 2), with each value return is seperated by comma, and remove same value if there's any.

Attached the excel file for sample.

I am a newbie, Try for few hours yet unable to resolve, hope someone can help me out. thanks

Thanks alan & kvsrinivasamurthy for the help.

There's a mistakes in the excel file i attached earlier.
here's a updated revisions. basically, the D columns(sheet 2) need to match the value of its respective A,B,C(sheet 2) with column A(Sheet 1) and extract matching values (Sheet 1column B). If there's multiple matching in column A, then it will extract multiple values

samples - REVISED.xlsx