How to make a new excel shet using macros

Hi,
i'm new to excel macros, and don't belong to programming fraternity, so right now i need to build a smart macro which can do the following:
Let us say this is how my excel sheet looks
sheet1:

1 2 3 4 5
A Aone Atwo Athree Afour Afive
B Bone Btwo Bthree Bfour Bfive
C Cone Ctwo Cthree Cfour Cfive
D Done Dtwo Dthree Dfour Dfive
E Eone Etwo Ethree Efour Efive

above are the contents of my excel sheet, consider it as a matrix.
now i want to create a new excel sheet which will contain a column with all my cell data mapped with their corresponding row column index, i.e., as shown below
Column1 Column2
Aone A1 // look above where is 'Aone', it is in row 'A' and column '1' so column 2 will contain 'A1' alongside
Atwo A2 // look above where is 'Atwo', it is in row 'A' and column '2' so column 2 will contain 'A2' alongside
Athree A3 // look above where is 'Athree', it is in row 'A' and column '3' so column 2 will contain 'A3' alongside
Afour A4 // look above where is 'Afour', it is in row 'A' and column '4' so column 2 will contain 'A4' alongside
Afive A5 // look above where is 'Afive', it is in row 'A' and column '5' so column 2 will contain 'A5' alongside
Bone B1
Btwo B2 and so on

refer the above table to understand clearly the scenario..........
Even now if u don't get it, then let me make it more clear:
I need to create a macro which should do the following:
1-- Creates a new excel sheet
2-- should transfer all the data in each cell(from the current sheet) as a single column data in the new excelsheet.

In furtherance i have attached an excelsheet which has two tables which will give you a clear picture, the table above is the current sheet( input table) and the new sheet should contain the data as described in second table (output sheet data) below .

Please guide me with your invaluable inputs.

Thanks