In sheet 5 cell D9 just type = into the cell and then select the sheet and
cell you want it to be equal to and hit enter. It will display whatever value
is in the target cell.

Guy

"msao" wrote:

I have some sheets that i enter a person name and adress on and i would like
it to be entered on a nother sheet automatically and i am really new at this.
I enter the name in sheet 4 Cell D7 and would like the same text in sheet 5
cell D9.

Thank you