Hi Ezrael,

See Ron de Bruin's sample code at:

http://www.rondebruin.nl/copy3.htm


---
Regards,
Norman


"ezrael" wrote in message
ups.com...
Is it possible to do the following?

I have 12 separate spreadsheets in 12 workbooks that contain data in.
Some column names are common to all 12 (PLANT COUNTRY INDUSTRY TYPE
SURVEY RESPONDENT), other column names (different data) are only common
in some of the 12 and there are few column names not common but just in
one sheet.

Want to be able to merge the data from the 12 workbooks into one.


Appreciate your help on this.