trying to freeze a sheet

I have multiple sheets as part of my excel calculations which refer to the first sheet in the group. Each one calculates different values for me based on the numbers I put into the sheet.

So to put in these numbers, I insert new rows to the start of the sheet which is what I always want it to calculate. Some of the calculations are comparative to other points from my original page. So I might ask it to go back and compare to 3 months ago or 6 months ago.

Long story short, when I insert those new rows, the formula on the other pages shift down to stay on the previous days data. How can I lock it in so it stays focused on just the cell I tell it to reguardless of how I move those cells around. So when i hit insert, I still want it focused on that sheets A1 and NOT A2.

I attempted to look up the help section but since I am having a hard time putting this into words, help was not much "help".

If anyone can point me in the right direction here it would be most welcome. Thank you,

Jason

When I attempt that it says there is an error.

For example the sheet it is referencing is called Current while the sheet I am on is called lw

So the way its set up now is...
=Current!A1

I tried both of these below and it game me an error saying I could not do it.
=Current$A$1
=Current$A1

Thank you so much, this was a huge help.

Well the code worked but when I went to look at my numbers today, they all shifted along with the first page. So instead of it being A1 when I inserted the new row, the second page is now referencing A2.

from second sheet
=Current!$A$1

After inserting a row on the first sheet this is what the second sheet reads
=Current!$A$2

Any more ideas?

Works perfect so far, thanks a ton!