Combine two .xls spreadsheets data inot one

I need someone to Combine two .xls spreadsheets data into one. There may be some columns that are named differently so just put the data across as a column and i can cut and paste it into the correct place. Once all the data is in the correct sheet i aim to create scatter plots of each column against the "Av mic score" Column

I need all the data in "Agronomic Data 21.22" put into "Master Data Sheet 21.22" - Please keep all the formatting the same in "Master data sheet 21.22"