Hi Louise

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Louise" wrote in message ...
I have approx. 30 workbooks that i need to consolidate into one book. They
all have the same column headings, however, the data underneath each heading
on every workbook is different.

Is there any way I can 'consolidate' these workbooks so all the information
is listed under the same headings, rather than copying and pasting???

Thank you.

Louise