Gnatt chart - list cells from 'tasks' columns based on date

See the example sheet attached. 

I have a Gantt chart with a list of tasks on the right and dates along the top. 

On a new sheet, I would like to be able to select a date range with the result being a list of tasks that are active within that date range.

Thanks very much in advance you wonderful bunch!