At the moment I have over 40 workbooks sent to me each week, each workbook
has 3 -4 worksheets in it detailing the previous weeks work. I then have to
open each workbook and then go to each worksheet and copy the details fom
the previous week (approx 10 rows) and paste them into a single workbook
(which summaries the various workbook) Can the above be carried out by some
f orm of macro. or programming (am I in the correct forum?)

My issues seem to be
How do I select the correct information from the correct worksbook / sheet.
This should not be too bad as the new weeks work is always in the same
position each week. ie from A3 to L12. Although on the next worksheet it may
be A5 to M16 (but it will always be in those positions on each week)

The second part of the probelem is how to add it to the bottom of the new
summaried sheet each week.

Any help greatfully received.

Bob