Formula for Text instead of numbers

Hello,

I am trying to get text to appear on one Excel worksheet when I enter it into another Excel worksheet. Both worksheets are contained in the same Excel doc.
Example: [Sheet1] Column A:Row 1 - "Susie Sunshine"....then I want "Susie Sunshine" to automatically be entered on [Sheet2] into the cell I assign in.

I am able to do this with numbers but is there a way to make this happen with words???

Any help would be greatly appreciated. Also, feel free to spell it out for me as I am new to Excel and may not understand a lot of codes, etc.

Thanks, KP