Using the cell that is selected for the value in a formula

Hi all,

I am wondering if something is possible at all. I have a calendar on Excel (month-by-month) and then another sheet with all the dates of all the different events that are happening. 

I want to be able to click on a date in the calendar and then below, a list of the events that are occurring on that day appears. I more or less have the lookup side of things sorted but I do not know how to make it so that if someone clicks on the date then the list will appear. Essentially, I want to use the selected cell as the 'lookup_value' in the formula. 

Is this possible at all? Do I need to use a macro?

Many thanks

Sam