hi... I'd love some pivot table help!

firstly: -

when i add fields to the pivot table (eg, drag in using the wizard), they
are always 'sum of' or 'count of', but i normaly want 'average of' is there
any way to adjust this (ie, change an option in preferences) or is there
some vba i can use to change all the fields in the data area to 'average
of'? whenever i've tried, it always seems to refer to all available fields
rather than those in the pivot-table.

secondly: -

i have collected data from several different production sites and i want to
make several summary pivot tables quickly/easily; can sometime tell me how i
can use vba loop through each site creating a new worksheet of sumary data
for each of the sites?

thanks for any pointers you can give me,

Tim