Trying to update column from backup excel sheet

[nmccracken12]

I have a massive excel file that when someone sorted it A to Z... A few columns got messed up and did not sort properly. I have a back up file that has the correct info and both of these files have a column A that are numbered and match. Is there a way for me to tell the master file to pull the info from the backup file to fix this? I am unable to copy and paste due to the A to Z sort and multiple new items added since the mess up, however column A matches perfectly for all items that were there.

Master
Column A = list of numbers matching
Column AV, AW, AX = wrong

Backup
Column A = list of numbers matching
Column AV, AW, AX = correct