I hope this is simple enough to answer. I just can't seem to figure out where to find it.

How can I take text that is entered into 1 worksheet and have it transfer to another worksheet but not in the same cell. Say I want put my name in a data sheet and it transfer that name to a different cell within a new sheet.

Any help would be greatly appreciated.