Get the name of a Cell and the value thats in there

[Seanzies]

I created a workbook that looks like a catalog it has merged cells in it.
What I want to do is take the name of each cell (ie. J01BRNMED) and the value that was entered into the cell and paste that information into another spreadsheet.

Heres an example of whats in Sheet1 (all of the ... equal are spaces, I just wanted it to line up correctly.)
..........A..............B..............C.............D...................E................F
1.....STYLE#.....COLOR.......MEDIUM.....LARGE........TOTAL UNITS...COST
2......J01............BRN............1.............2...................3..............15.00
3......J02............BLK............0..............1..................1...............15.00
4......J03............NVY............2..............3...................5..............15.00

In cell C2 the name of it is J01BRNMED, and the quantity ordered is 1 unit.
What I want to be displayed on Sheet 2 starting in Cell A1 is the name of Sheet1's Cell C2 and then is cell A2 the number that was entered in there.
For example, and it doesn't have to look exactly like this but similar,
Sheet2
A B
1....J01BRNMED......1 (this is the easier one which I know how to get this to show up by doing a formula ='Sheet1'!C1)

Can any one help me? I tried to make this very easy to understand but can't figure it out.

Also, how can you make excel to except a number to be included in the name of a cell? ie. J01BRN

Thank you,
Seanzies

 

[Seanzies]

Added info

I am using Excel 2003 with Windows XP Home Edition SP2