I do 3 different comparisons between 3 different sheets and normally use a
vlookup in each one then extract the relevant information to make a
difference report. is there not a macro i can use to reduce this comparison
process?

Thanks