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?