Calendar won't auto populate for start stop dates

I've been working on a shorthand calendar for my office's shared outlook calendar. We have too many people and too many things going on to printout the normal office calendar and when we can get it to fit it's too small to read well.

my calendar works great when the events are only one day, but if they last longer it only shows the first day. I'm not sure how to work my code to change that.

Also for some reason my vlookup function doesn't want to work when grabbing employee id numbers. It either gives me a #N/A or REF! error and I can't figure out why.

I uploaded the calendar below.
Thanks for any help.