Create Dynamic Validation List & Then Pull Related Data into Sheet

Hello Excel Gurus.

I've spent a couple days searching MANY forums for a solution to 2 tasks i'm trying to complete with No Luck
to what i'm looking to accomplish.

I have a Sample WB to reference.
SampleWB.xlsm

OK, First I'd like to see if i can Create a Drop Down list on the "Today" sheet in "A1"
that is Dynamically Populated with all the Dates found on the "Data" sheet. This data is the final, cleaned up
version of data pasted in there after a macro runs to get it looking the way is does in the sample. The amount of columns
will remain the same after every clean up but the # of rows can be variable along with the potential amount of names and which
rows the dates fall on.

Second, the end goal is to be able to select a date from the drop down list and then create a list of people working that day
and their shifts. Anyone who is Off or has a value other than a time listed would default to Off.


I always try to self serve before posting as i'm trying to learn on my own but obviously need some help with
this. I respect all your input and Thank You All in advance for any and all replies and pointers.



Thanks
Scott