Transpose rows from multiple sheets into new sheet

Hi all,

I am having a problem which I have been tackling for several days. Any help will be useful.

In the attached workbook, I would like a macro which copies and transposes data between sheets 'Statistics' & 'Master'.

So in sheet 'makecopy', it needs to

1. Transpose data from B2:B12 and paste it in Flatfile in row A.
2. Transpose data from D2:D12 and paste it Flatfile in row A (in the first available coloumn)
3. Transpose data from B13:B42 and paste it in FlatFile in row A (in the first available coloumn)
4. Transpoe data from F2:F42 and paste it in FlatFile in row A (in the first available coloumn)

Then,

1. Transpose data from C2:E12 and paste it in Flatfile in row B.
2. Transpose data from E2:E12 and paste it Flatfile in row B (in the first available coloumn)
3. Transpose data from C13:C42 and paste it in FlatFile in row B (in the first available coloumn)
4. Transpose data from G2:G42 and paste it in Flatfile in row (in the first available coloumn)

You might get a better idea when you look at the workbook. Any help will be massively appreciated!!!