Convert Multiple Columns to Rows depending on an Input Value

Hello All,
I have lot of data in Excel 2010 which I wish to bring in Columns using a Macro depending on the input value which the macro should prompt me.
For Eg:

A1 B1 C1 D1 E1 F1 G1 H1 I1 J1
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10


If I select data from A1 and J1 (in practical it will be more Columns) the Macro should prompt me how many Columns would be the output on Master Sheet.
If the input is 2 then it should create an output Sheet ‘Master’ and should show the following result
A1 B1
1 2
1 2
1 2
1 2
1 2
3 4
3 4
3 4
3 4
3 4
5 6
5 6
5 6
5 6
5 6
.. ..
.. ..
It after selection I run the macro and input 3 then the output should go in three columns (A1,B1,C1) one below other. If 4 is Input then 4 Columns (A1,B1,C1,D1) will come below each other so on and so forth.
I hope this gives the idea.
Any help would be greatly appreciated.
TIA
Rashid Khan