Pivot Tables, Multiple Worksheets, Different Column #'s, Needs to be in 1 Master

[maverickballa24]

Hi all,

I have 30+ excel files that all have an inbound pivot table with a varying different # of column headers. Some files have all of the possible combinations and some do not. They are sometimes in the same order and they are sometime not. I need to have a way in order to consolidate all the data from these tabs into one master table. I am struggling with knowing what the best way to do this would be. If you have any suggestions on how I can do this please let me know.

Thank you
Scottie