Copy a Google Sheet, Into Another Workbook. Sure, Sounds Easy...It's not copy & paste.

Copy a Google Sheet, Sure, Sounds Easy...

Sometimes someone will send you some information that is in its own workbook. One sheet, one workbook, per person who sends you information. Sound familiar? Then you have to select all, Ctrl + C, and Ctrl + V it into the main workbook you were already working in. Then...start reformatting. Been there, done that. Over it. There's an easier way.

1. At the bottom of your page, click on the drop-down arrow next to the sheets title, most likely it'll say 'Sheet 1' unless your sender organizes their sheets. 
2. In the pop-up, click 'Copy to'
3. Select the workbook you want it to go into, it does NOT even have to be open at this time. 
• Type the title or keywords of the workbook you're seeking in the search bar
• Click on Recent and select the workbook you are seeking
• If you're not the owner of the master workbook you're seeking, look in the 'Shared with me' section. 
4. Click the blue select button after the workbook has been selected.
5. Your workbook is copied! Click OK to close the box or click on 'Open Target Workbook' 
• When you open the targeted workbook you have one more step.
6. Click on 'Copy of <Insert Sheet Name Here>

That's it. Super easy! Did I lose you? Here's a short tutorial if you need to see it in action.