How do i create a "by date" dropdown list from other excel docs
 

I am trying to create a single worksheet Calendar, that will display multiple
text data, in a Daily date related dropdown list, from same date related
cells in other workbooks. Can you assist with what order the cell
formulas/filters/Links or inputs I need to do to get correct daily result.
Or is there an easier way of linking dated cells from ten or more other
calendar based workbooks to display in one workbook?
Help