I want to lookup a date from a workbook to add to a specfic cell in another
workbook, can this be done?

I've tried a vlookup but this would mean that I will have to consolidate the
sheets in one workbook to do this and this take too long and copy the
consolidated data on to the workbook I want to do the lookup with and this
does not always work. I'm looking for a quick way of doing this.
--
Laurette