Spreadsheet Automation for basic formula

We need someone to create a formula or some form of automation for us to check data from one spreadsheet and return the results into a 2nd spreadsheet.




From 1st Spreadsheet( Source Data.csv)

goes cell by cell

Copying the information in each cell in Column Z

Then

Searching for this in 2nd Spreadsheet ( information.csv)

Results are found in Colum F

and returning the data in column I

Copying this

and entering into this back into 1st Spreadsheet (Source Data.csv) into column AC