title: excel 2013 copy data from column A sheet 1 to column A sheet 2 and 3
body: <p>I have a work book with multiple sheets. 
  I want the infomation in sheet 1 column A to populate in sheet 2 and 3.
  I have used " =sheet1!a10 " and that works to a point. When I have to change the data on sheet 1, either insert or delete a row, theh formula does not carry over. Also I am counting the rows, and using " =sheet1!a10 " puts a number value in addition cells throwing off the percentage.
  is there a way to lock the formula in a cell and also not count empty cells? </p>