creating list with input from several sheets

[dearly]

I am attempting to have several users input onto different sheets. What I would like to create a sheet that has a running list that will update as inputs are put in? This is not actually done in microsoft Excel. It is being done in Google sheets.

Example
Sheet 1 Sheet 2 Sheet 3 Sheet 4 Sheet Compilation
Kenny Alec Tim Mike Kenny
Bob Alexa Derek Lisa Alec
Joe Anna Anthony Brian Tim
Seth Doug Derek
Mike
Lisa
Bob
Joe
Alexa
Brian
Anthony
Doug
Anna
Seth

 

[dearly]

[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Example[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD]Sheet 1[/TD]
[TD]Sheet 2[/TD]
[TD]Sheet 3[/TD]
[TD]Sheet 4[/TD]
[TD]Sheet Compilation[/TD]
[/TR]
[TR]
[TD]Kenny[/TD]
[TD]Alec[/TD]
[TD]Tim[/TD]
[TD]Mike[/TD]
[TD]Kenny[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]Alexa[/TD]
[TD]Derek[/TD]
[TD]Lisa[/TD]
[TD]Alec[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Anna[/TD]
[TD]Anthony[/TD]
[TD]Brian[/TD]
[TD]Tim[/TD]
[/TR]
[TR]
[TD]Seth[/TD]
[TD]Doug[/TD]
[TD]Derek [/TD]
[TD][/TD]
[TD]Mike[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Lisa [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Bob[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Joe[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alexa[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Brian[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Anthony[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Doug[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Seth[/TD]
[/TR]
</tbody>[/TABLE]