Hi mdmackillop

Thanks for your response - I never knew it was possible to read the contents of excel sheets and dump them to an access file. Presumably all of the workbooks could dump to the same mdb file simultaniously and the summary would import the contents of the mdb?

With regard to the data some of the cells will be formula results from calculations on other sheets within the workbook. It's only about 10 cells or so per workbook which is a collection of dates, figures and text. I'm not at work at the moment so I've cobbled together a rough (very rough!) idea of what I'll need to take from each workbook and how it's currently presented on the summary.

Thanks for your continued help with this, it's much appreciated

Cheers,
rrenis