I am trying to put data from multiple excel spreadsheets in to one workbook.
The layout of the spreedsheet I want to put the data in to is different to
the other workbooks. Is it possible to transfer this data across so that it
automaticaly changes it to the layout I need.