I am trying to build a holiday tracker. I need to have a worksheet that, on the first tab, allows the user to fill in details such as:


I will then have 12 tabs with each month of the year.
Each tab will have a grid with 1-31 (or however many days are in that month) at the top and each persons name down the side

I need to write a macro that will fill see the details inserted in the first tab and make a number one appear in the relative grid, so if someone fills in as follows:

name: Matt Smith
day: 5
month: September

a number 1 will appear in the September tab at the grid point where Matt Smith and 5 overlap

I hope this makes sense and that someone can help

Thank you