I want to set up a function that will look in a sheet and bring the text
contained in a cell to another sheet.

For example, cell A1 in sheet 1 contains the text "Mike". I want the
contents of A1 to be replicated in cell A1, sheet 2. If I change "Mike" to
"Jim" I want A1, sheet 2 to update to "Jim".

I can do it with numbers by simply using the autosum function but it doesn't
work with text.

Many thanks, Guys

Simon