Importing Subsheet Data to a Master Sheet

What i need to do is

1.) Create a MasterSheet to track cases
information need to track is case name, case number, date opened, date closed, date sent to another unit.

Three supervisors will have their own sub sheet to input information from their specific team.

how do i set the master sheet up to pull data from all three sub sheets and compile the above information on the master sheet?

is this even possible?