title: Excel macro to update links from other spreadsheets
body: <p>I am trying to create a macro that I can apply to my worksheets.</p>
  
  <p>Scenario:
  I have a workbook that is like a summary page. It has links to the hardcoded numbers from other workbooks. In many instances, the folders have been moved around or a sheet may be renamed/removed, etc. The links end up failing and it causes many #REF errors. THis happens because multiple people can manipulate the spreadsheets on the shared network drive.</p>
  
  <p>I would like to solve this problem by creating a fail safe. Essentially, an "update" button that would save a copy of all the references that were updated into a new worksheet named "updated data" and add a timestamp to when the last update was performed. This data would change only if there is a change to the reference.
   For example, if on Monday, cell A1 references a workbook's cell A1 and returns the value $1234.56, it will store the refernce in a seperate worksheet. Now, on Tuesday I click update, and the the reference A1 workbook has been moved or deleted. I will still return the $1234.56 rather than the #REF. Finally, there is some kind of notification that the update failed, would be great, maybe highlight the cells.</p>
  
  <p>Thanks for reading and providing your insight.</p>