I am creating a schedule sheet in Google Spreadsheets that will have a number of different people inputting their own information. I would like the Director to be able to open a single document that "gets" each of the employee's sheets and compiles into one document. Is that possible with Google Spreadsheets?
I am currently setting this up so am flexible, for instance whether all employees enter into the one document or each has their own. My plan was for each employee to have their own sheet and also have one document containing a copy of each of these individual sheets. i.e. Single sheet for each employee (of which there are 5) in separate documents along with one document containing 5 sheets (one for each of the employees).