Copy column formular to paste to other column by highlight the column and insert the target column and paste there

1) Copy column formular to paste to other column by highlight the column and insert the target column and paste there.

2) copy the other sheet to a new sheet by just paste the value of the sheet.


3) sorting out the wanted data.