update a file from another with different structure

[tomi707]

Im very new to VB an i have to do a script that transfers the data of one worksheet to another one.
i have one master file. there the date will be entered manually. looks like this:

location | Loc1 | Loc2 | Loc3 ...
Value1 | 100 | 150 | 0 .....
Value2 | 99 | 125 | 0 .....

For every month there is a tab created with the same structure.
What i need to do is to update a Worksheet with this data in an other structure.
Should look like this:

Month | Jän | Feb | Mar ...
Value1 | 100 | 75 | 2 .....
Value2 | 99 | 10 | 17 .....

and a tab should be created for each location.
Is it possible to do this and how would be a recommended solution?

Thanks very much
Tom

 

[tomi707]

Sorry i took the wrong word upside. i have to transfer from one workbook to an other one. not only worksheets