Automatically gathering of information

Hi all Excel experts! ☺

I have a question where I think I´m expecting to much of excel, but I hope someone can help me with this problem or a workaround.

I have a list of project hours from the start of 2015 until now. The sheet contains about 6000 rows, numerous projects, employees and description.

I´ve attached a smaller and simplified version of the sheet.
In column A-E the raw data is put in. To get this into the accounting system I need to categorize by:
Month – Project – Worker – Description and then finally calculate the hours.
Eg. In cell K5 John has done two painting jobs in January (2+8)

So, Is there anything in excel that can do this or a version of this automatically??
Or does anyone have a good workaround that can give me the same result without tons of work ☺

Thanks
Project hours.xlsx

Thank you so much for a quick and good answer!

I have never used pivot tables before. Is it possible for you to wright a quick step by step guide?!

Secondly: Do you know if its possible to automatically calculate by project and month? Eg. 10 hours in Pr 3 – January.