Formula to search value across multiple sheets

Hello all!

I use spreadsheets for training schedules, and currently have a formula that searches the employee name across the different session tabs to either return what session they're on or "Not Scheduled". This has been working great, however I've had a request to change this so that it returns the course date rather than the session number.

This is the formula I'm currently using:

Formula:

Please Login or Register  to view this content.

Here is an example spreadsheet for reference: Example.xlsx
This formula can be found on the Employee List tab, column D. The Session_List table is on the schedule tab, column F (hidden).

When I try to add another column to the Session_List table to reference the dates (B5 to B11) the formula stops working. Is there a way to have the formula search through the session tabs for the employee name, and return the course date?