I have a workbook that has seven tabs for the days of the week and each sheet
is identical except for the date in A1. I have a number of cells on each
sheet that are linked to another workbook to pull inventory information from
it. File name example Inventory MM-DD-YY.xls Right now, in order to update
the sheet on a weekly basis, I use find and replace to search for all
instances of last weekending date and replace it with the current weekending
date. What can I do to simply enter the new weekending date in a cell and all
the formulas will change automatically?