title: How to replace intermediate indirect cell references
body: <p>In attempting to denormalize X,y,Z, coordinate data that I described in a previous post, I ended up creating multiple sheets that reference each other.</p>
  
  <p>The result is that I have many cells that just reference cells on other sheets. For example, Cell Sheet1!A1 is "=Sheet2!E200" and
  Sheet2!E200 is "=SomeFunction(Sheet3!K25)"</p>
  
  <p>Is there any way to replace all such redirections to another cell without modification with a direct reference to the terminal cell?</p>
  
  <p>In my previous example, Sheet1!A1 becomes "=SomeFunction(Sheet3!K25)" </p>