Hello. I have 2 workbooks for our horse shows: Qualifying1Merge and Qualifying2Merge. Once the horse shows are finished I would like the results combined and moved over to a third work book (qualifying Eng Results Merge). Each class has it's own sheet in each workbook. EAch matching "First Name, Last Name, Horse's Name, Club" is a unique record. In the results workbook there are the columns just mentioned and then a column for Danish and Points from each qualifying show. (there are two other columns as well that I've already placed formulas in). I need a way to combine unique records from both shows onto the corresponding sheet in the results book and then put their Q1 & Q2 data in the appropriate columns. I hope that made sense. I filled in some dummy info on the SR. SMS sheets. Thanks for any help

qualifying2merge.xlsmqualifying1merge.xlsmQualifying Eng Results merge.xlsx