Unsure of how to collate data on Excel across sheet using drop down lists

Thanks Riny_van_Eekelen 

The calendar and table were the original format given to us for tracking achievement of the KSB targets. 

Using the calendar you see which days you did activities that used one of the targeted KSBs, then the table is for recording what you did and which specific KSBs were used in doing that activity. 

So we are supposed to note down on the calendar the hours and type of activity; the coloured drop down box which has the SUM for total hours at the bottom of the calendar. 

You have helped solve this issue, thank you. 

Next to explain a little more about KSBs and how it ties in with what I need.

In the table is a column with a breakdown of the exact KSBs which is what I am trying to track and I think I need a Pivot table to do it but I am unsure of how to gather that data. An example: I do an activity which hits both K4, K5, B2 and S4 I would put that in the last column of the table, I thought I could make a named range using the 'KSBs' sheet which would make a drop down to select K4, K5, B2 and S4 then have it update in 'Total KSB Hours' to show how many times KSB was used.  However, the list doesn't work as each cell can only have one drop down list selection. But as you can see each activity can have multiple KSBs achieved.