i have data in sheet one in one column and say many intermidiate rows

i want to copy that on a new sheet and then sort that


can anyone tell me how to do the linking using VBA


thanks in advance
indraneel