At a simple level:

Open both the Excel files.
Loop through the source Excel file, assigning each row to a Record variable.
    Inside the Loop, use a combination of Set Cell and Go To Cell to put each column of the record variable into the target Excel file.
Save your target Excel file.
Close both files.

See these documents for more information:
https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-excel-command.html
https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-loop-command.html

Also visit the Pathfinder Academy and watch the “Getting Started With Excel” video. It shows you exactly how to do this. It’s free!