Hi Guys,
i know theré's a very similar post on this subject, but it is intended for use when you knwo the other workbook name.
In my case, the workbook name will depend on date, client name and product. To cover this i have used some simple formulas using "concatenate" and "&" functions to get...