BY THIS YOU CAN COMBINED TWO EXCEL SHEETS INTO ONE NEW WORKSHEET. YOU CAN ALSO FILTER DUPLICATE VALUE AND UNIQUE VALUE.
THIS IS THE EXCEL VBA WORKSHEET, YOU CAN MODIFY AS YOU WANT.
IT WILL BE VERY HELPFUL FOR YOUR WORKING.