Question: how do i automatically copy data from one google sheet to another?
Answer: On your computer, go to docs.google.com/spreadsheets/. Open or create a sheet. Select a cell. Type = followed by the sheet name, an exclamation point, and the cell being copied. For example, =Sheet1! A1 or ='Sheet number two'! B4 .