Furthermore, here is the sequence of the loop. Copy and paste from "Debt" AE10 (down and to the right) in this case to AS45 and transpose in Statatest C2 in every five rows until C72. Next, Copy and paste from "Productivity" C6 (down and to the right) in this case to Q48 and transpose in Statatest C3 in every five rows until C73. Copy and paste from "Terms of Trade" AE10 (down and to the right) in this case to AS45 and transpose in Statatest C4 in every five rows until C74. Same loop for sheets "REER" and "FX" which are pasted in C5 and C6 and finish at C76. Does that help?