Macro function for link data & update data

Dear All
In our manpower requirement we have the fixed no. of manpower requirement for each contract. The manpower requirement is defined in the contract document and based on that we have to recruit and provide the manpower to our client.
Here the manpower is recruited and how to maintain the join and left and their information from the summary. Also to get data and update the record of employees at the same table.
Need by clicking the data in the total available (E+N) and to show the employee list relevant to the category.
Enclosed the sample file with two sheet “MP Summary” is the contractual requirement and the available manpower and the Sheet “Employee List” is the data of each employee
How to do in Excel? Pls help me in this as it will reduce lot of my time and proper records.

Regards
Regina