Changes to VBA in this excel.

I have had an excel with vba code from another person.
This VBA copies the names from a column to another column a number of times.
I would like to change it that names are on another worksheet, and the copy has to go to e certain worksheet and places, also names number of times beneath eachother, and number of empty rows.

Could somebody help me.

Guido