We are using a workbook for our payroll. The file has aheet with every
employee's name plus a summary page. The file is 5.67MB. The summary page
is linked to each employee sheet. The summary page has 7 rows for each
emplyee that is linked to the emplyee's sheet. If you move a sheet or remane
the sheet the cells linked on the summary page don't automatically update.
example cell D3 on the summary sheet would be =Blank14!$C$3 if you go and
change the linked employee's sheets name cell D3 will only update if you
double click the cell. Is there a way to have it auto update?

Thanks,
Chance