dynamic / auto duplicate count?

Hi all, is it possible to automatically count current and future duplicates entered within a range, as I want to show data in a pie graph. The data below is extracted from another worksheet as it is filled in. Thank you