Okay guys i need help!!

So basically what i ended up doing was adding 5 columns with column headings (1-5) and auto filled those columns with =""
and recorded the pivot table macro. This worked like a charm!

However, the problem is that now when I change the column headings (1-5) to something else and refresh the pivot table, these changes aren't reflected and the column from the pivot table gets deleted.

My question now is can I change the pivot table macro in such a way that it's flexible with the column headings?