Master Excel tables

Good day, you want to design a simple sortable table
on three sheets
a) a list of employees
b) a list of equipment
in) summary table (under which the employee, what technique) on this sheet should:
to be able to add