title: How do I keep Cell Referencing in Excel if I replace sheet?
body: <p>I have a sheet with a bunch of data. I then have a different sheet that references multiple cells in that first sheet. If I want to delete the first sheet and replace it with an identical sheet (identical in every sense, ie sheet name, data type in each cell, format, etc, except for the actual text data in each cell), the references in the other sheet are lost, and all my cells produce a #REF! error. </p>
  
  <p>Is there any way of preserving the references and replacing or overwriting the sheet, without having to manually cut and paste the information?</p>
  
  <p>Thank in advance,</p>
  
  <p>George</p>