Referencing Other Worksheets AND Using Fill Handle

[izzykel]

I have 2 worksheets I am using, one has numbers going horizontally:
A1 B1 C1 D1
A2 B2 C2 D2
A3 B3 C3 D3

One a second worksheet I am referencing to those cells, in a veritcal format (the refernces as follows)
A1 A2 A3
B1 B2 B3
C1 C2 C3
D1 D2 D3

I have over 40 pages of this to fill in and would normally use the fill handle, but it skips.. like this..

A1 A2 A3
C1 C2 C3
E1 E2 E3

Is there any way that I can fill these in without having to manually type in the formulas? In addition, there are spaces between every 2 sets of numbers.

 

[izzykel]

Heres a copy of the table...

 

[izzykel]

Maybe this better explains what I want..

<center> <table border=2 width=90% cellspacing=5 cellpadding=8 cols=5>
<tr><td></td><td>a</td><td>b</td><td>c</td><td>d</td><td>e</td><td>f</td><td>g</td></tr>
<tr><td>1</td><td>1065</td><td>2005/06</td><td>31500</td><td>27405</td><td>4095</td><td>12.396</td><td>83.80</td></tr>
<tr><td>2</td><td></td><td>2006/07</td><td>29097</td><td>27410</td><td>1687</td><td>12.396</td><td>29.58</td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total</td><td>113.38</td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
<tr><td>3</td><td>1066</td><td>2005/06</td><td>39521</td><td>34384</td><td>5137</td><td>12.396</td><td>105.04</td></tr>
<tr><td>4</td><td></td><td>2006/07</td><td>36506</td><td>34389</td><td>2117</td><td>12.396</td><td>0.00</td></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td>Total</td><td>105.04</td></tr>
</table></center>

Column G is coming from another worksheet: "Money."
G1 has a formula which reads "='Money'!D60+'Money'!E60 "
G2 reads "='Money'!F60+'Money'!G60 "
G5 reads "='Money'!D61+'Money'!E61 "
G6 reads "='Money'!F61+'Money'!G61 "

My problem is that I have (I was wrong earlier) over 1300 rows, of which 2 are filled, then a total of those 2 (G between 2 and 3 on this example), then an empty space, 2 filled, total, empty, etc. Instead of copy and pasting the formula into each cell, or typing in each formula, I would like use the handy fill handle to auto fill the formulas. This generally works with things like "sum" and can work when referencing other worksheets, but I have never had a horizontal to vertical transfer before.
I hope someone is able to help me..