So, if you do have duplicates in the two sheets, how do you want this
to be handled? Add the data together?

How many columns do you have in each sheet, and approx how many rows in
each sheet?

Are both sheets in one workbook?

Pete