Consolidate worksheets

Excel 97- I have six worksheets by month (cols.)and days (rows). each cell contains a dollar amt. that I want to sum by day and month plus total for the year and month onto a separate sheet called "Totals". Additionally, if I should insert or change data on one of the six worksheets I want it to be automatically reflected on the Totals sheet. I've used the consolidate data command but it only works after all the data on the individual sheets is completed. Not dynamically or automatically.