Creating a daily report

Hi All,

Wishing you all A Very Happy New Year !! :-))

Am attaching a Excel sheet in which In entered the data manually.

I would really appreciate some help in how to automate it either using vlookup or pivot tables etc.

The consultants Joe, Harry, Shawn and Phil on a daily basis find different job profiles and rate them.

In the report tab I would like to know how many profiles have been selected by Joe, Harry, Shawn and Phil based on rating by each of them daily and a sum of them.

Please note: in their respective sheets they can fill in watever job profiles and it must automatically change in the report tab sheet.

Thanks In Advance...!!

Really appreciate some quick help on this

PS: I might add some more rating columns as well like A++(+)