Thank you! I'm running into 2 corner cases that's preventing this from working:

1) When an employee doesn't have vacation booked (i.e. there's nothing to match to in the Out of Office Tracker tab), the gantt doesn't populate, and
2) If column A is left blank but there are dates (i.e. the task hasn't been assigned yet, but the task is still needed), the gantt doesn't populate.

Any ideas?