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]

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

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>