In Excel 2003, is there an easy way to change horizontal cell reference to Vertical cell reference?

For example i have 31 sheets, each for the day of the month, and in the first page i have a monthly summary. of numbers from these 31 sheets.

so i have:

5 10 5 5 20 5 5 (costing) from day1 (sheet) for example and associated references for these numbers are J81, k81, l81, m81, n81...r81 etc. These are displayed horizontally

i want to copy thse numbers AND Most importantly References onto the monthly summary sheet table which is my first sheet, but vertically

so i want to paste this reference into the monthly summary (first sheet) to references:

J5, j6, j7,j8,j9,j10 etc

so it displays like this:

5 = j81 (of second sheet)
10 = k81
5 = etc
5
20
5
5

without doing it for every single cell which takes so long.

Thanks all.