I have created 30 workbooks that feed into 5 summary/database workbooks, my question is, rather than having to change the source location for the database(destination) to link to, if I change the workbook name (to say that of a person rather than the original "workbook 1" title) is there a way for the destination database workbook to automatically recognise the change in the source book title. If so How?