VBA How to copy ONLY non blank cells (1 Viewer)

[skdn71]

I cant seem to find a solution for my worksheet after endless searching.
Is there a way copy a range of cells sheets "Copy From"( Empty and name )
and then paste into sheets "Copy To" ONLY the Name without the empty cells ) are being copied to ( See foto)
I have tried many alternatives bu no success :

 

[Gasman]

Set the filter to non empty cells, then copy?