Make a formula stay in a cell

[Jvic28]

Good Morning everyone,

This is my 1st post but there will be many to follow I'm sure as I have lots of things I would like to do.

My first query is this:

The 1st sheet of my spreadsheet is a summary page. And I need it to list cell A3 of all the following sheet. However the information is cell A3 on the following sheets need to change occassionally and to do so I will move the current information in the those sheets downwards to keep the updated information at the top. I was going to just insert a line to do this but noticed that on the front sheet the formula then changes from ='CS1'!A3 to ='CS1'!A4.

Is there a different formaula I can use to make sure no matter how many line i insert, it will always pick up A3 and not move down the sheet.

I hope that make sense.

Thanks

[teylyn]

Hello Jvic,
welcome to the forum.

Try

=Indirect("CS1!A3")

or

=Index(CS1!$A:$A,3)

cheers

[Jvic28]

That seems to work, thanks.