i'm not sure SUMPRODUCT will solve my problem.

I do need a certain layout to the results - and also then add some data from another workbook to the top of it.
It requires grouping on two different levels and then summing the data in rows T to AE.

i'd really rather find out if its possible to specify a cell reference in the PivotTable VBA as mentioned above.

this is the line that is the problem:
With ActiveSheet.PivotTables("HighLevelFOB").PivotFields("T1")

I need to tell it to look at a named worksheet and take the contents of cell T1 to be the field.