I am creating a master template for a work camp. Each member organization
has its own worksheet listing all of the attendees; they will complete these
forms at different times. I need a master list for all attendees.

How can I fill in the data from each identical sheet into a different sheet?
Can this be done automatically (for example when group 1 updates their sheet
on Monday & Group 2 updates on Tuesday, the data is filled in automatically
both times)?

Thanks in advance for your help.