Welcome to the forum, and sorry it took so long to get an answer back to you. I was ridiculously busy this past weekend.
I've filled in some formulas for you, but I'll warn you that th formula to pull back the hours is fragile. Your data sheet is in a difficult format to work with. With multiple rows for some areas and not others, it takes some work to make sure the right data is coming back.
At any rate, this sure work for you.