Question: how to transfer data to another excel sheet?
Answer: Copy and Paste Link. From source worksheet, select the cell that contains data or that you want to link to another worksheet, and copy it by pressing the Copy button from the Home tab or press CTRL+C. ... 
Enter formula manually.