Referencing date string in worksheet tab as part of formula to determine if deadline met

I am hoping that it is possible to reference a date string in the worksheet tab name in a formula.

Production worksheet tab name format:
Planning_DD-MMM-YY

Number of production worksheet tabs per workbook:
3

Deadline lookup table:
Deadline_Dates tab

Formula I am looking for to determine if a WO is completed on time or not:
Based on date in production worksheet tab (ie., Planning_12-Oct-17), the formula would check the 'Deadline_Dates' lookup table for the deadline listed for 12-Oct-17 (in this case 05-Apr_17) and determine if the deadline has been met by comparing it against the date listed in Col G (Date_WO_Completed), and then populate Col H as follows:

• If date in Col G is < or = to deadline date, then Col H = 'Yes'

• If date in Col G is > than deadline date, then Col H = 'No'

• If Col G is blank, then Col H is blank.

I have included a sample spreadsheet with the 3 production tabs and the desired results listed in red.

Thanks,
Andrea
Index_Match_Date_Deadline_Worksheet.xlsx