checking if a date/date range already exists in 4 other date storing tables

Hello,

I appreciate the expertise you guys provide!

I have a userform that employees use to submit a date/range of dates (12/14/2014-12/30/2014) for their vacation requests. The workbook has several tables that store different types of leave (vacation) dates in them (Company Holidays, Personal requests, Fridays off, Weekends).

For the userform, which inputs dates to the "Personal requests" table, I am wondering how to check the dates that are being requested against the other dates that already exist in the tables to be sure that dates being requested don't overlap with existing vacation. I would appreciate any recommendations.

The file is attached.