linking worksheets and files
 

I have a worksheet that records sales details from 3 separate tills and
calculates total sales for the day etc. One of the figures from each till
gets carried forward to the next day (and varies each day)
At the moment I have this set up as a week to a file with 7 separate linked
worksheets. I then copy the file and redo the dates, then manually link the
last day of one file to the first day of the next. (Hope that makes sense)
Is there an easier way to do this in Excel where I dont' have to manually do
things.

thanks
karen