Help with Advanced Filters and Sumif's

Good morning everyone

I've tried to solve this for some hours but I haven't succeeded, I hope you guys can help me.

From the list I'm attaching, I need to sum all of the hours spent on a certain Work Order and leave only the newest record (and show it on a different sheet) for that order with the total hours spent on it. There's an example on the Excel sheet.

I hope this makes sense. Any help will be really appreciated. Thanks!