Thanks xor. However, I dont want the literal word, "anything". Im actually working with addresses, and the default wording is "New Zealand". However, in some cases I want to send to a country overseas. So, I may type the word, "Australia" or "United Kingdom" or "Germany". In those cases I want the cell in sheet2 to return the same word that I typed in sheet1.

Sorry that my O.P. wasnt clearer. Can you suggest again?