I created a payroll workbook and am having trouble with absolute cells and referencing the cell that I need.

I want to be able to reference a cell on one worksheet page, for example the formula in cell E3, and have the information appear on a different worksheet within the same workbook. I've been able to do this successfully, but my next step is causing me trouble.

I want to be able to insert rows in the first worksheet (the current week's payroll), so the formula in E3 will move to E4, but the current E3 will now have the formula that I want to reference. I want the second worksheet to ALWAYS pull the information from E3.

After copying the cell reference into the second worksheet, I have tried entering it as $E$3, but when i go back to the first sheet and insert a line, then return to the second sheet, the cell reference has been updated to $E$4.

Is this possible?

Thanks for any help...