I need to copy and paste a linked formula and have that formula update automatically. Here's what i am trying to do...I have a workbook with 31 worksheets, one for each day of the month. Each worksheet has two columns; one with opening numbers and one with closing numbers (to track sales of gallons of gasoline) I need the closing numbers to link to the next worksheet under opening numbers. I have created the linked formula but when I try to copy and paste it to a new worksheet the original cell reference is still in there. Is there a way for the formula to automatically update referencing the previous worksheet? Doing this by hand is becoming tedious.