Please help with macro or formula to auto populate master schedule from multiple subsheets

[AmberMoran]

Hello,

I have a large workbook that contains a master nursing schedule which is updated weekly (it has a date in the bottom right hand corner) and several subsheets divided by Nursing positions (RN, LVN, CNA, etc) and then by dates (6 weeks worth of) and hours. Is there a formula or macro that would allow me to enter hours on the subsheets and then auto populate the master schedule with just the names that correspond to the dates entered?

Thank you,

Amber