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