find and replace the 2 spreadsheets...

Is there a way of having 2 spreadsheets where the 2nd one searches the 1st one and inserts the row when the 1st one doesn’t have the row of the 2nd one?