Hi

Still a novice I'm afraid!
I have a large amount of statistical data that needs to be moved from workbooks to master workbook sheets to allow a stats formula ( I already have) to analyse the data.
Example.
Data from workbook 1 columns B7:B106 and AB7:107 to be moved to master workbook sheet 1 - columns B4:B103 and L4:L103 respectively
At the same time I would also like it to move workbook 1 columns L7:L106 and R7:R106 to master sheet 2 - columns B4:B103 and L4:L103

Then Workbook 2 column B7:B106 and column AB7:107 to be moved to master C4:C103 and M4:M103 and
L7:L106 and R7:R106 to master sheet 2 - columns C4:C103 and M4:M103 respectively
so it is moving the data from the same columns in each workbook to the next columns in the master sheets
for a total of 10 workbooks

The workbook and master format is standardised and does not change. however I will need to change the coulmn selection at a later stage but I presume I can do that by tweaking the formula!
Is there a way of doing this on opening the workbook or even if I have to copy and paste the workbook contents to a user sheet that will then transfer the cell information to the master sheets it would still be much quicker and save me thousands of copy&pastes!

Any advice greatly appreciated

Regards
Paul