Urgent Help needed

Hi

I need a formula/procedure to calculate which expert has interviewed how many candidate
on daily bases along with the count of their status like on hold,rejected,shortlisted.

There is one consolidated sheet for all experts I want to pick data from that sheet to fill the below mention sheet on daily basis.

please help me asap!!!

[email protected]



Expert Monday-16 may -11
Status Line Up Shortlisted On Hold Rejected Offered
Sam
Rakhi
Vibhor
Ram
prem




Main sheet tabs:

Date of Interview Current Status Recruiters's Name Day week