Question: how to transfer data from one sheet to another in google sheets?
Answer: In Sheets, open a spreadsheet.
In an empty cell, enter =IMPORTRANGE.
In parenthesis, add the following specifications in quotation marks and separated by a comma: The URL of the spreadsheet in Sheets. ... 
Press Enter.
Click Allow access to connect the two spreadsheets.