Excel formula auto text?

will i use any formula autosum, for instance:when sheet2 A1 put text “apple”, sheet1 A1 are going to be appeared word “apple”

Sheet ONE PARTICULAR cell A1 =Sheet2! A1

Autosum may be for summing numeric files; it is just not used along with text.