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