Merge from 3 google sheets

Need to merge data from 2 google sheets. Need program to copy file name from file name column then compare the copywrite column from the second sheet to the access code column on first sheet. Each time there is a match between the copywrite field and Access code field a new row needs to be created on the first sheet with all the info from the row with the matching access code and the filename from the second sheet be pasted into the first column of the row that was just created. Attached files show the first sheet, second sheet and final product