Hi,

I have several Excel documents with several sheets in each.

I want to be able to take data from each and collect in a seperate document

eg, i want to add together cell A200 from document 1, sheet one to C106 document 2, sheet 3 to D406 document 3 sheet 2 and have the result appear in document 4

I hope that makes sense

Thanks for any help

James