VBA macros for multiple matches in different sheets

[pasumpon]

HI

I need a macros for multiple matches in different sheet and need to return the all values for unique id
I put an example case for you
Sheet 1 contains unique ids and values .Values will repeat

In other sheet also values will repeats and will value corresponding values for the each repating values

I need output like for one unique id all values corresponding values as i provided in the example .

Please help

Thanks alot

Sheet1 contains

id1 isin1
id2 isin1
id3 isin2
id4 isin3

Sheet2 contains


isin1 value1 age1
isin1 value2 age2
isin2 value3 age3
isin3 value4 age4
isin3 value5 age5
isin1 value6 age6
isin3 value7 age7


Output


id1 isin1 value1 age1
id1 isin1 value2 age2
id1 isin1 value6 age6

id2 isin1 value1 age1
id2 isin1 value2 age2
id2 isin1 value6 age6

id3 isin2 value3 age3

id4 isin3 value4 age4
id4 isin3 value5 age5
id4 isin3 value7 age7