Custom Sort VBA PIVOT Table

[jbiehl]

Hello Amazing Mr. Excel World!
I have hundreds of PIVOT tables that all need to be sorted in this order:
Pre-Test
September
BOY
October
IA1
November
December
January
MOY
Februrary
March
IA2
April
May
EOY
June
Post-Test

The custom lists in advanced options isn't a great solution since there are so many.
Does anybody know of a way to sort these using VBA or a macro?
Thanks in advance!

 

[jbiehl]

I still haven't found a solution for this. Does anybody have a work-around for "custom sort" being grayed out in Pivot tables?