I am trying to pull just the information with yesterdays date from a closed workbook into a different open workbook.
This is the set up of the data:

Date Shift Min. Down Equipment Reason Explained


So if it has yesterdays date I want it to pull onto its own sheet in a different workbook.