Link to a workbook using a cell reference

LOL!
Peter we do not need to know how awesome your PC is (5820K!!!) to help with your problem.

The problem is it appears you are trying to use some sort of indirect function with a closed workbook and that doesn't work.
You CAN use VBA to pull the data in instead, but I am not sure if you are wanting that.


In the past I just created a dataset and had a column for DATE, then you can just filter on the date, or do a lookup off date off the ONE dataset, instead of multiple workbooks. Really, when you have multiple workbooks it gets to be a pain in the rear.
If your data is larger than 1.048M records you can use access or SQL or MySQL and/or PowerPivot.

Ha, yeah I laughed because that is a nice PC and we dont really need to know that info.

Indirect has a lot of great uses but I don't think it will work on closed workbooks.
You CAN have a vlookup on a hard coded workbook name, then just find and replace that name everyday. I find that more annoying than VBA so I would pull the data in via VBA.

Thanks again Mike for your thoughts. I'm trying to avoid having to do anything, typing or even clicking a button and thought about a macro that ran upon opening but this is a new sheet every day. This code would just be pasted in with the other daily information in one go.

Then I would likely have a Summary workbook that pulled in the last TWO days and compared the, likely with VBA.
This gets around your issue of a new workbook each day.