Yes you can automate pivot table manipulation or creation.
http://www.thespreadsheetguru.com/bl...l-pivot-tables