Pull data from another workbook:

I have two workbooks. One is a weekly schedule with column A containing "Names" and columns D-J are for each day of the week. Each name could have a corresponding time for each day, be it 1500 or 1700 or simply off that day.
The second workbook, I'd like to generate a list of everyone working (for example) Monday and sortable by times (1500 or 1700).
Further complications are the naming of the schedule workbook which changes. I'm thinking VBA perhaps and a button for a folder picker that picks the file rather folder to be used to pull the names/times from?
Is this a pipe dream or something that can be accomplished?
I could provide examples if needed.

These are samples of the two workbooks. The "Road Map" workbook would be pulling data from the "Schedule" workbook.

JeteMc, Thank you for the response and I do agree with you. Stepping into my current position, there were separate workbooks for everything and none of them communicated with each other in any fashion. I like to think of ways to increase productivity and office efficiency which leads to less time spent at the desk and more time interacting with team members. I've managed to incorporate ways to do so with some of our workbooks. My main challenge is very few people have access to the "Schedules" workbook and are left with printouts of these schedules. Road Map is currently filled out reading off a printed schedule for example. My main struggle is attempting to consolidate spreadsheets without disrupting the current workflow of management. A way for those who have done it a certain way for years and do not really know (I wouldnt say better) but different.
To be honest, I have learned more about excel in past year just trying to do things the hard way, so to speak.

I have created daily tables in the schedule workbook that i can copy and paste the values into the road map. If I must continue to keep these workbooks separate, this is an easy choice. Definitely beats copying from a printout.

Thats great JeteMc. I'm working on dealing with changing schedule names. Schedule is currently named in a format such as "March 16-March 22.xlsx" and another for "March 23-March 29.xlsx".
Thank you JeteMc!