Join two sheets automatically


I have a sheet of employees
Employee ID

and another with tasks
Task ID
Employee ID

Is there a way to automatically create an inner join table on a separate sheet with these fields, using Employee ID as the joining field? This table should update itself any time there’s an entry on any of the tasks table.

Employee ID | Name | Task


You could directly create a field Name on Task sheet, and set link and load on it.
Employee ID would be linked field and new field Name would be loaded field.