remove duplicates and delete empty cells

Hi there,

I have a set of data in one column of "Sheet 1". I want to remove the duplicates and delete all empty cells. However this set of data with removed duplicates and deleted cells shall then be posted in "Sheet 2". The first set of data must be in cell B6. The title must not be shown. In addition the cells in Sheet 2 must not have any formatting.

The button to activate the duplicate remover and empty cell deleter shall be on a third tab "Sheet 3".

Attached is an excel file which shows the task and the desired output.

I am sure this is pretty basic but please help me as I am an absolute beginner regarding VBA.

Thanks in advance.