Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging. 

I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid


In Sheet 1, a user enters a course code (e.g., BUS 123) in one column. Smartsheet searches for that code in Sheet 2, finds the corresponding program leader's name and e-mail address, then puts them in two cells in Sheet 1.

Now Sheet 1 shows the course code in Column 2, the program leader's name is