Question: how to copy data from one google sheet tab to another?
Answer: Copy the URL of the target Google Sheet. Open the Google Sheet that has the tab you want to copy into the target sheet. Right click the tab you want to copy. Choose "Copy to > Existing Spreadsheet" Paste the URL into the bottom of the window that appears. Choose Select. Rename the tab in the target Google Sheet if desired.