Linking workbooks

I just want to say hello! -and, i hope you can help!
I have a master schedule at work that changes frequently . . . as in days off change or people are away on holidays, etc. what i am looking to do is to only have to update this one workbook once a week and have that automatically update my dailoy schedule -as in the schedule that i look at each day to tell me who should be there and who shouldnt be there. i have no problems linking workbooks but i am having difficulty trying to figure how (and if) it is possible to have only certain information show up in my daily schedule. i am not sure if this even makes sense!

let me try to explain further: when someone is on days off or away for vacation/sick time there is the information on my master schedule that they will be away but what i am wanting to show up on my daily schedule are the people who SHOULD be there. . . and, then if those days off change and i need to switch them on my master schedule i would like the change to automatically be reflected on my daily schedule.

if anyone can help it would be appreciated! if there are any other questions, please, ask!