Question: how to transfer data from one google sheet to another?
Answer: Step 1: Identify the spreadsheets you want to combine. Pull up the two spreadsheets that you'd like to import data between. ... 
Step 2: Grab two things from the original sheet. ... 
Step 3: Use a Google Sheets function to port your data over. ... 
Step 4: Import your data.