Display info from a separate report by matching the date

Hello all,

I'm trying to get one report (that is created daily) to pull information for that date from another report (which is build more like a database, containing all the daily info for the entire year thus far). These are two separate workbooks in separate folders.

On the first report, I have the date set up automatically with =Today()-1. I'm using the -1 because the report is created around 3 or 4 in the morning the next day, but is reporting the previous day volumes and times.

I was trying to get a formula that would compare the date cell at the top of the first report (ex. A1) with column A (which is the list of dates for the year) on the second report. Once it found a match, it would then pull the corresponsing info from column C (volume) and column D (finished time) of the second report and display them in cells (ex. B5 and C5) on the first report.

If any more information is needed, please let me know.
Any help would be greatly appreciated.