I am trying to create a central results sheet that will collate results from
numerous other workbooks. The data in the workbooks to be referenced is in
the same place in each workbook. Is there an easy way to reference the data
without having to link the cells individually. I thought you could copy and
paste the cells in the new workbook once you had referenced one cell, but
this sometimes works and sometimes doesn't. I hope I've explained this ok!