One sheet populating a master sheet.

Is it possible for one sheet be filled in with information then once saved, it will auto populate the same information onto another sheet (the master sheet)?

For example, master sheet is called "Fruits". 10 people are assigned to a different fruit. One person has their own smartsheet called "Apples" another person has a sheet called "Grapes". When they input information on their own sheets, those information will go to the "Fruits" master sheet.

Best Answers