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
employee that is linked to the emplyee's sheet. If you move a employee sheet
or rename the sheet the cells linked on the summary page don't automatically
update with ab=ny changes. 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 on its own or
with a macro?

Thanks,
Chance