Hi All,

Has anybody got any code or can point me in the right direction to do
the following efficiently:

Example:

Sheet1 : Main worksheet with 80 columns of data and x rows
Sheet2 : Data to be appended to Sheet1 say 20 columns and x rows
Sheet3 : Data to be appended to Sheet2 say 60 columns and x rows

The difficulty here is that Sheet2 has 20 columns and only the columns
that exist in Sheet1 should be appended to Sheet1. The column titles/
headers/text in each sheet are identical but because the number of
populated columns is only 20 the layout is different. Also where the
same columns do exist they may not be in the same order (eg Sheet1
ColA = Apples, ColB = Pears......Sheet2 ColA = Pears, ColB = Apples)

Sheets3 has the same problems.

Hope l have explained this clearly

All suggestions gratefully appreciated

Michael