I have about 1000 different Workbooks. EIn each one the data has the same
structure A:G but of course different rows each one.
The first thing I need to do is to create a summary line in each one
summarising the rows C:G.
Then i need to get this summary line from each one of the 1000 wokbooks and
and create a summary sheet.

Any ideas?