if i got u right :

Activate last sheet-tab where u want text
hold down SHIFT-key
activate all other sheet-tab u want the text
Activate the cell u want text and press =
Activate the sheet and cell where text u want to copy is
Hit ENTER

copy text to all activated sheets and selected cells