I need to create a list of unique values from a range of columns. For
example, say Columns E - G are as follows:

E F G
Bob Dave Bill
Rick Steve Dave
Steve Rick Fred
Bill Joe Steve

I would end up with one column with the unique names:

Bob
Rick
Steve
Bill
Dave
Joe
Fred


If it is possible, I would like to have the Unique list in a separate sheet,
update automatically and not use a Macro (VBA). Is this possible?