Best way to display text from another field in spreasheet as a comment on hover

I'm not sure if I will explain this properly but I am not sure if this is the best way to do this. I have been asked to create a dashboard of a calendar for data relating to two different types by day.

Attached is a spreadsheet showing part of the problem. There is a spreadsheet called "Calendar Overview" that is being used as part of a dashboard to highlight the calendar items listed in worksheet "Admin".

In "Admin" the user selects a day and adds a data type from the drop down values of ;
Off work
Other
Performance Targetted Key Competition
Squad Training
Training period

And then adds a comment in the appropriate row in column E

I would love the user to be able to hover or click in the Dashboard spreadsheet " Calendar Overview" in a day and they see the corresponding comment.

For example if in the "Calendar Overview" spreadsheet I clicked on cell C4 - I would love the user to see the comment from the worksheet "Admin" E2.

I have searched to see if it is possible to allow the user to hover and found that I can add code to the worksheet activate call. But I am struggling with it as I am looking across at values and not down as many of the examples have shown.

Any help in the right direction would be greatly appreciated. I'm not even sure if there is a better way to do it as I have racked my brain and got a lot of mush.


Many thanks