Using one form to create multiple sub-mastersheets


I am sending out a form to be populated by staff members. I need the info to be fed in a mastersheet. In addition, the members have separate managers and I would like for thesis managers to be able to view only the staff that they manage (on a separate sheet). Is this possible?

So in summary I need the following:

  1. All info to be fed into 1 mastersheet-This I can do
  2. info to be fed to individual managers who should only view info for the staff assigned to them and not not the entire mastersheet.

Thanks in advance

Best Answer