Function for turning cells into a list

[Chandler8]

Hello all, so I need a formula to grab all of the peoples names in random cells from one sheet into another sheet while creating a straight down list of the names! And, if there is a way to (prompt/warning) when there is a duplicate name while not posting it to the list that would be very helpful! I have listed some pictures for examples below. Thank you very much!

Ex..xlsx
	A	B	C	D	E
1	Random_Guest 1	Random_Guest 2	Random_Guest 3	Random_Guest 4	Random_Guest 5
2	Billy Bob	Kellie Bob	Bradyn Bob
3	Kayla Ming	Joe Smith
4	Bobby Doe	Joey Lawrence	Larry Bill	John Corley	Kelc Corley
5	Ashton Piercing
6	Ashur Low	Tim Low
7	Lauv Smiley
8	Lola Jean	Michael Jean
9	Kayla Pearson	Michelle Pearson
10	David Kurt	Lindsey Kurt	Kiley Simb	Larry Simb
Names

Ex..xlsx
	A
1	Guest_List_Names
2	Formula Here/to generate the names with ability to drag down (one name per cell)
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
List

 

[Fluff]

Are you dragging the formula down the column?

 

[Chandler8]

Are you dragging the formula down the column?

I am, yes.

 

[Fluff]

Then don't, clear that column & then put the formula in a single cell & it will spill down.