How do to stop a formula from update when row added

[chastroD]

I am attempting to populate a table with data entered in a second sheet. The second sheet will be updated every month with the new figure


in sheet 1 called YoY:

in cell b3 I have

=data!B2

in cell C3 I have

=data!B3

and so on


in Sheet 2 called data:

in cell A2 I have January
in cell B2 I have 25,000

The problem is...that when I add a new row to data sheet, and type February in A2 and 26,000 in B2, back over in sheet Yoy the formula has updated so now

cell b3 I have

=data!B3

C3 I have

=data!B4

What I want is so that no matter what I do in data, YoY never tries to change formula and that C3 Always is =data!B2.

How do I do this?

Thank you in advance

 

[arthurbr]

One possibility would be =INDIRECT("data!$b$2")