autofilling equations from pivot tables across worksheets

[Michaelson]

I posted about this in this thread but it was a kind of long an unwieldy OP with a vague title and I don't expect it to get a response. I'll try to be more specific and to the point here.

I'm using Windows XP and Excel 2007.

I have a bunch of data in pivot tables that I'm using as source data to generate specific statistics in a separate worksheet.

Pivot table:

Stats sheet:

Basically I've been entering the formulas for the stats sheet into into every cell individually, but I'm hoping to get autofill working to speed things up and avoid careless errors as much as possible.

So in the picture from the stats sheet the average Gold Coast 'Second Half For' value is derived by the formula

=('PT1'!P8+'PT1'!P29)/('PT1'!K29+'PT1'!K8)

If I highlight that cell and drag the fill handle across, however, in the cell for Manly's average 'Second Half For' it pastes the formula

=('PT1'!Q8+'PT1'!Q29)/('PT1'!L8+'PT1'!L29)

which is incorrect. If you have a look at the pivot table what I need is for it to generate the formula

=('PT1'!P9+'PT1'!P30)/('PT1'!K9+'PT1'!K30)

So basically the auto fill is scrolling across the pivot table table rather than down it. Is there any way to rectify that and have it generate the correct formula? From my searching of the forum it looked like I might have to consider macros, but as I have no idea whatsoever what they are I was hoping there might be an easier fix!

Thanks in advance, and apologies for the double post.