How do I always have one cell in a different worksheet always reference H34 cell of another/different worksheet in the same workbook

[mechengineer]

I have a worksheet that I always want cell J157 to reference the worksheet DailyElectH34, but as I delete and add rows on the dailyelect page it moves it up to H33 and so on, what formula can I use to always have the first worksheet reference the DailyelectH34 worksheet without it moving as I delete and add rows etc.

And DailyElecH34 has a formula of =G34*$H$2


Thanks in advance for all help!

 

[JoeMo]

Name the cell that's currently H34 on the sheet DailyElect. See Excel Help - Named Ranges.