Mapping of cells to other cells on other sheets based on certain condition

[pumelayurika]

Hi guys,

I need help on creating a self-plotting spreadsheet that can also populate a number of days per month on its own depending on the year-month combination.
Example: if it is March 2016, there are 31 days according to the standard calendar
“Plotting of Shift” - Tab (see pic)
plotting1.jpg
“Shift Summary” - Tab (see pic)
summary2.jpg
Below is a sample of the plotting of the names and their respective shifts: (I am aware of the Vlook up though… but the days of the month will be compromised if I used that, I need to re enter manually if I will use v-lookup)

(above: “Plotting of Shift” – Tab, Below: “Shift Summary” – Tab)
plotting mode 3.jpg
Here are the sample files:
shift plotting4.xlsx
Thanks and Regards,
pum