Looking for some advice/assistance.



I work for a title company and we have many tracking spreadsheets across our shared drive for our company. I've created one master sheet that references the individual spreadsheets using a simple formula where I type "=" and then highlight all of the cells from the individual sheet.

For months this worked great where whenever someone updated an individual tracking sheet, it would update my master tracker, but suddenly it stopped.

I tried deleting and recreating some of the tabs on the master tracker with no luck.

I cannot attach the spreadsheet here as it is too big, and also contains sensitive company information, but does anyone have experience with this type of work that can give some advice? Thank you in advance!