I am trying to find a macro that will automate the process of creating multiple pivot tables. I have a large table with a column for month and year and then about 20 columns for time series data. What I'd like is a pivot table for each column of data, with each pivot table in a new worksheet. It would be a bonus if I could automate the naming of the worksheets based on the column heading. Any ideas?