Excel Import Data from Different Workbook Dynamic Headers
Copying and pasting isn't necessary and interferes with the user's paste cache. Clear the target column of data and then set a range in the target the same size as the source. Then use an assignment statement:

TargetRange.Value = SourceRange.Value