VB Code to display and count duplicates

I am looking for a way to identify duplicates across multiple columns in excel, list each dplicate in another sheet, and display how many times each duplicate field occurs. (See attached fo desired results)

Thanks in advance.

Met