Need to consolidate the data with an effective formula

Hi Friends,

I have various sheets with the info of employees and this is for various clients.I need to consolidate data employeewise for various clients.The sheet contains three sections Overall forecast as per capacity,H&M phase forecast and Fixed phase forecast.I need formula to calculate H&M phase forecast employeewise for all clients.Fixed phase forecast is already formulized and overall forecast capacity will be sum of all months.

Pls its urgent help me with an appropriate formula.


attaching sample sheet.

Regards,
Aps