Hi,

I was wondering - I need to iterate through a set of identically formatted workbooks (values will be different in key cells of course).

For each workbook, I need to extract 2 worksheets that I will place into my consolidation workbook. The workbook code will extract the data required based on a worksheet that I have created (so the worksheets that are imported must have the same tab names to ensure that my formulae work). results are stored in a final worksheet - 1 row per import. On the next import, the two worksheets will be deleted and replaced by a fresh new set. Hope this makes sense.

The problem is, I have no idea how to perofrm the open/copy-append part of the code. I am an Access developer by trade, so VB is not the issue. It's the Excel way of working that I am having to learn the hard way! :)

If anyone can help me, I would ve very grateful indeed!

Many thanks.