Day and Shift wise allocation from Roster / employee shift schedule

Hi Excel Experts,
We have different separate worksheets for Roster / employee shift schedule of different categories like..SEAL CHECKERS - Supervisor, SEAL CHECKERS, GEAR BOX MAN, MEPL - RMG/ICD LASHERS etc., wherein D = Day, N = Night, Off = Weekly Off etc.and for day allocation we require one more summary sheet which will for allocation, in which after selecting specific Date & Shift from drop-down lists, names are to be displayed on that allocation sheet. How can it be automated with the help of vba or formula? (ref. attached file for the same)
Kindly help me in the same
Ravi