I have 2 sheets, sheet1 and sheet2. In sheet1 I have data that I will manually be moving up or down monthly. In sheet2 I need it to copy the contents of a specified cell. The problem is that when I move the row in sheet1 the information in sheet2 follows the cell. Ex. Sheet1 cell a1=x and cell a2=y. I need sheet2 to display sheet1!A1 even if I move a2 in its place.