I have a spreadsheet with columns from A to AE
The last 12 columns all contain months from the month AFTER the current month TO 12 months away.
e.g. nowm, they will show DEC05, JAN06, FEB06 .....etc

The rows contain a numerical value which represents the number of hours put
The other two columns I am concerned about are C and D - column headings ALWAYS stay the same.

I need to create a pivot table automatically that will always use the cooumn headings from the worksheet (whatever they are)
They'll exist in the same place, but obviously each month the pivot table is created, the month headings will be different.

how can I do this?
Is it possible to create a pivot and point to a cell reference when telling it which columns to use??

thanks in advance...