Excel 2007 : Need Excel to calculate data from multiple sheets onto a master sheet

Hey everyone, first time poster here. I recently got promoted at my job and it requires me to use excel. I am some what familiar with the program and I can work the basics. What I want to do seems to be a little bit out of my league. Here is my situation. I have a sheet for every day in the month of December as well as a master page displaying all totals. This sheet is to keep track of the number of phone calls that come in, the data that needs to be entered is Cust Name, Appt Made, Appt Date, Appt Show, Appt No Show, Sold, Source, and Rep. Now I have two people taking the calls everyday. On the master page I want to have the Individual reps that are taking the calls and for excel to calculate there number of calls taken, appts made, appts show, appts no show, and sold, separating the data between the two on the master page. I do now know how to do this and I would help me out alot because I need this separation of data for statistic purposes and we get a little over 100 inbound calls a day. Thanks for your help.