How to copy specific columns data from multiple excels and paste into another excel

Hii,
basically i have some 10 excels every time i have to copy specific columns data and put into another excel sheet under those specific columns

Hi,

You can use excel recorder activity for the use case mentioned

Regards,
Amit Anand