Excel formula

Hello,



Hi,
In excel, I want to sum the values in different sheets using conditions. Daily production details of employees are updated in excel. In the first sheet i want the automatic updation of the total production of the month. Here there is one problem, in each sheet, employees names are vary. so we cannot add the values using the cell values. so i need to add the values using some criteria,or employee names, or using macros.