Creating a unique list of values from column of data across multiple sheets, no blanks

I have 6 worksheets in my file.
In sheets 1-5, column A2:A26 list people's names. Some people's names appears on more than one sheet. Not all cells are populated with a value.

ex.
SHEET1
COLUMNA
Bill
Todd
(blank)
Steve
(blank)
Ed

SHEET2
Todd
Bill
Ed
(Blank)
Dave
Bob

SHEET3
Ed
Dave
Bill
(blank)
Alfonso

I want sheet 6 to list all non-blank values that have appeared in the previous sheets, but list them only once...
So
SHEET 6
Bill
Todd
Steve
Ed
Dave
Bob
Alfonso

My attempt was... =INDEX('Week1:Week5’!$A$2:$A$26,MATCH(0,COUNTIF($A$1:A1,’Week1:Week5’!$A$2:$A$26),0))
where the sheets were Week1-Week5 and the values on each sheet was A2:A26. But I think there's an issue with Excel being able to 3D reference for these types of functions. Any other ideas?

It's not :P but I was dabbling with that. So if I went that route, what is the easiest way to create a single column of all the data, removing blanks, if possible?

I did the clunky thing of directly copying A2:A26 from each of the 5 worksheets into 5 separate columns on sheet 6. Then copied each of those 5 columns on top of each other, so I had a sixth column that was relatively long, and mostly filled with blank spaces. It seems like there has to be a "neater" way to do this than that? I'm also not removing any blank cells with the formula I got. So I'd get 1 unique (blank) in the resulting array.