Question: how do i copy text from one excel sheet to another?
Answer: Highlight A1, Copy (Ctrl+C) it, go to the cell in sheet 2 where you want the formula to go and Paste (Ctrl+V) it. Excel will adjust the formula to =Sheet1! A1.