Consolidate and Remove Dupilcates

In B34 is one stock ticker followed by 20 more stock tickers in B37:B56. The second example's tickers are in B64 and then B67:B86. There will be more examples added over time. Can someone help me write a macro that will combine all of the tickers and then remove any duplicate tickers. The final consolidated list should be on sheet2 starting in cell A1. Thanks!

Can anyone help me with this?