Arrays to Column Vector

Dear All
I am in need of a macro, which is able to transform two 64x64 dataarrays on each worksheet into columns of 4096 datapoints each in such a way that the order of cells is kept equal across files. I do additionally need to apply this macro to >3500 files - Can anyone help? Please note that the second array per worksheet is always the transposed first array - Maybe this reduces the programming effort? Here is a (size-reduced) example of what I need

Example of the problem: Two small starting arrays:
1 2 3
4 5 6
7 8 9

1 4 7
2 5 8
3 6 9


The type of transformation I need:
Normal Transposed
1 1
4 2
7 3
2 4
5 5
8 6
3 7
6 8
9 9

Problems I hit were related to a) The macro being much too long (and hence wouldnt run) and b) My unability to make this macro run automatically on all files in a folder (in my case these are many). I am quite sure I owe this problems solely to my own clumsiness, so - please enlighten me!
Thank you very much in advance for your time and suggestions!

I would post this in the programming section (with a sample), since it involves opening >3.500 sheets.

//Ola


If it was just a few sheets...:

A1: upper left corner in matrix
=OFFSET($A$1;INT((ROWS($B$1:B1)-1)/3);MOD(ROWS($B$1:B1)-1;3))