DO you want the names from each column underneath each other in one column or do you want to keep them in 3 columns? What is the name of the destination sheet and where on that sheet do you want to copy the names?