This is a question about an Excel problem.?

I have a workbook that contains (a) a master list of employees on one worksheet; (b) five sheets each representing a day of the week with names of employees in column A and hours worked in column B; and a summary sheet with names of employees in column A, and total number of hours worked per employee in column B. Not all employees work every day; that is, not all the employees are named on the weekday worksheets and the names are not in the same order on the weekday worksheets. I want to calculate the number of hours worked per employee on the summary sheet. I want to do this with one formula in each cell of column B which is beside each employee name of column A. The closest I came was by adding a table on the employees sheet which calculates a cumulative total of hours per employee. Then on the summary sheet I just put =Employees!G:3 (G4, G5, etc.) for the total number of hours per employee. My formula for each employee in the table is: {=SUM(IF(Mon!$A$2:$A$11=A14,Mon!$B$2:$B$… of course putting columns for each day of the week and linking each sheet for each day. A14 (A15, A16, etc.) equals the name of the employee. The range of cells in column B are the hours. I think it would work on the summary page if I could get this accepted: {=SUM(IF(Mon!:Fri!$A$2:$A$11=A14,Mon!:Fr… but I can't get the range of sheets accepted with the range of cells. Our teacher says to use LOOKUP combined with another formula. Is this absolutely necessary? Someone did it in one step, but she said her formula was three lines long. There's gotta be a way! Thanks.