Show in a Cell the Value for another Cell

[LefepeCalambau]

I have a cell(B6) in sheet1 with a value anda I want to show this value in a
cell(C6) in sheet2.
What I do was:
in the cell(C6) in sheet2 I put: ='sheet1'!B6

This worked, but if I insert a line upper the line 6 in the sheet1, the
function goes like this: ='sheet1'!B7

Anyone can help me?

 

[Gary''s Student]

=INDIRECT("Sheet1!B6")

 

[LefepeCalambau]

Thanks Gary. This works great.

just an observation, the correct syntax is =INDIRECT("'Sheet1'!B6")

"Gary''s Student" escreveu:

 

[David Biddulph]

I can assure you that Gary''s Student has been using Excel (and advising
others) for plenty long enough to be aware that if the sheet name had spaces
in it he would need the single quotes around the sheet name, but he also
knows that without a space in the sheet name he doesn't need the single
quotes, so the syntax he used was perfectly valid for the question you
asked.