Updating info from 2 workbooks where file naness change weekly
 

I have 2 workbooks set up for tip data. In one are the hours, tips, etc. the
other creates individual tip sheets for employees based on the source
workbook. All the references in the seecond workbook point to the first
ex:[WE031007.xls]SUNDAY!$A$3. The only way I have been able to change the
reference date is by using find & replace ex: find WE031007 replace with
WE031707 replace all. This then updates the tip sheets with the proper date.
Is there a way to reference the workbook souce name and tip sheet workbook
pick up the proper name/date? Therby automatically updating the tip sheets

Barb