Pivot Table Macro

[Basic DB Question]

How do I have a macro populate the drop fields from the field list and
do the sum/count, in a pivot table?

I have users that just want to see end result, each time data is
exported.

Thanks in advance