Link sheets

[me2005]

Help me please! I have two spreadsheets for work that have to be completed on a daily basis by hand. The one on the left (MSR) is the base sheet that calculates daily/weekly/monthly sales for my store. The one on the right(NCS) has employee assignments, but the top sections refer to the the previous day's and current week and month's sales.

The NCS is being done for 7/8/2010. Using the data from the MSR on the left, is there away that I can have the cells update themselves in the NCS with some kind of link that can find the date in the MSR and take the appropriate data?

[martindwilson]

images are not very helpful post workbooks!