Create List based on criteria (VBA)

Dear all,

I hope you are all well.

I am struggling to create a VBA code under Worksheet SelectionChange event.

I have attached a test file.

In Sheet1 I have a table with some information.

Now in Sheet2 I need to create dynamic table based on selection (Yellow cells).

For example, in Sheet2, if a user selects a region (e.g. EMEA) I want to populate all employees ID; Name; *** and Manager name.

Tried to use functions but could not do it.

Any assistance will be highly appreciated.

Best regards,
Filipe