title: Is there anyway to make copy in Excel behave like cut?
body: <p>I'm having a lot of problems here... If I copy it gets messed up since I am not pasting in the same exact spot. If I cut I lose my block of information. If i do = then click and drag it gets messed up since the cells I am copying are actually references, so when I sort those references its bad news bears. 
  IE Sheet1 A1:E5 = data1 information
  Sheet2 Q5:U9 = 'Sheet1'!A1:A5</p>
  
  <p>On sheet 3, because of the way sheet 2 is setup, I cannot just go directly from sheet1 (due to sorting). I know this is a little confusing but TL;DR, is there anyway to emulate "Cut" without deleting the cells? .</p>