excel links

Hi,
My problem is of excel:
I have a workbook with worksheets for each day of month. Each worksheet will have data. I want to create a worksheet in the workbook that sums up all the data. also since each day i add a new worksheet i want summed up in the total worksheet…pls advs