I use Microsoft Excel 2003 to track daily sales for both the my store and
employees. I also track the sales on a monthly basis and prepare an end of
the year report. I use a separate workbook for each report.

I would like to know if it is possible to link the totals from each report
into one workbook or worksheet that will automatically update when I enter
the figures. This would save me a lot of time from having to prepare each
report individually.

Thank you,