sorry for messy..
the first priority is i have to make sure the reference key must be the same, then extract the data from the behind columns,
sorting is a good way to eliminate time, but not 100% sure that i can link the data with the reference key correctly.

For example:
A 100
D 200
DD 2000
C 300
E 500
EE 600

expected result ( after sorting of col A, in order to minmize the calculation time of excel)
A 100
C 300
D 200
E 500
DD 2000
EE 600

copy after sorting is good, but i cant guarantee the sorting must be correct to link the data.
If the sorting goes wrong as not expected,
and became this

A
C
D
DD
E
EE

just copy the data behind is taking a risk..
i want to minimize the time with linking the reference like vlookup to make sure the accuracy of data. i only can think of sorting in order to minimize the "looking for" time of excel.

And wanna ask for a better solution.