I am a school secretary. I created a master schedule in sheets. Based on that schedule, I sent a separate sheet to each teacher to create their own personal schedule. I created tabs and cut and paste each personal schedule into a specific tab/sheet labeled with that teacher's name. I did not want to cut and paste. I wanted to insert their actual document as a tab in the master file. How would I go about doing that?
There are several ways to do this, but the most simple I think as it doesn't require an add-on nor a script is the following one:
- Open each teacher spreadsheet
- Check that the sheet has the teacher name
- Click in the sheet name tab, select "Copy to..."
- Select the master schedule or paste the URL
- You could write the master schedule spreadsheet name or go to the recent tab
- Click Select