Date Picker, Required Cell input via InputBox, AutoUpdate Service Dates

Hello everyone!

I am working on a Vehicle Maintenance Tracker in excel for work. We have a fleet of vehicles we use for different purposes and they are serviced once a month.

I have attached what I have so far (not much).

I have tabs for each vehicle. For each tab, Column C indicates type of service. I would like when Scheduled is chosen, it correlates the Column D cell next to it with the value "Monthly Vehicle Fleet Service", but when Emergency is chosen from the Drop down list, I want it to popup an InputBox requiring input. When Ok is selected, it pastes the input in the Column D cell right next to it.

I would also like to figure out how to do a date picker for all the cells in Column F that is dependent on Column E being selected as "In Service".

My bad. I have attached it now.

I would also like to auto-update the "service Dates" using a Mon-Wed-Fri Pattern in the first sheet "Master", once that current month date has passed.