Hi, I am trying to collate data from multiple workbooks saved under a filename denoting the week commencing from which the data was collected e.g. "wc 2nd January 2013". Each of these workbooks are structured in the same way and therefore the cell references are all the same. What would be the...