Pivot data on many worksheets

[nickmax1]

I have a large workbook with many worksheets that is constantly growing (by month) Each worksheet apart from four which need to be excluded from this is identical in terms of layout, and i want to create a pivot table of data of each worksheet which will automatically refresh when a new sheet is added.

See attached.

I need to summarise by broker D18:D190 the forecast premium and bound premium (not added together but shown seperately) IF the Status of such ( range J18:J190) is either "Bound" or "Quoted".

I have attached two months worth (Aug 2012 and Sep 2012) but as time goes on Oct 2012, Nov 2012 etc will be added and i want my "pivot" to capture all of this.

Just in case its relevant to the macro the sheets "Template", "Graphs", "Start" and "Brokers" need to be exluded.

Is this possible with a macro?

pivot.xlsm

[nickmax1]

possibly sone kind of function with Sumifs?

[nickmax1]

anyone help me with this??

[nickmax1]

In case anyone was interested...solved it like this:

=SUMPRODUCT(SUMIF(INDIRECT("'"&tabs&"'!E18:E190"),$H8,INDIRECT("'"&tabs&"'!g18:g190")))

where tabs is a dynamic named range

=Start!$N$5 : INDEX(Start!$N:$N,MATCH(1,1/(Start!$N$5:$N$1000=""),0)-1)