Get list of unique values from dynamic range

Hi, I am trying to create a macro that will list the unique values from columns of data. (Usually between 2 and 5) This is easier to show than to explain - I have attached a workbook that has 3 columns of data, only 3 rows (the actual data is more) but the logic will be the same.

You can see the result column basically goes through each value of column A and then combines it with the values of column B and C.. with the row count increasing 1 each time -- again, this will make more sense after looking at the example.

Let me know if I need to clarify...

Any help would be appreciated!