title: Linking worksheets to a master worksheet and keeping values if the master worksheet is not present? Excel 2010
body: <p>I have many worksheets and at present, every 3 months I have to go through these one by one to update information in just a few cells.</p>
  
  <p>It would be great if I could create a master source file containing these few cells that get updated, that all my worksheets linked to, so that I could just update this file and all my files would then update.</p>
  
  <p>The only trouble I have is that I then send these worksheets out to clients by email, each client gets a specific worksheet.  </p>
  
  <p>This would mean that the local links to the master source file would no longer be there and I'm assuming there would be errors. Is there some way that I could link my files, as desired, to a master file, be able to update the master file and have all the other files update accordingly, but then send only a single file to a client and keep the values from the master file. </p>
  
  <p>I hope this is making sense! It's quite simple what I want to do, it's just a bit tricky putting it into words.</p>
  
  <p>Any help or advice would be great!</p>