I have multiple worksheets that have a table on each of them. They are all formatted the same with each heading being the same, in the same location and so on. I want to be able to create a pivot table on a different worksheet that will use all of the information in the tables, but when I have added all of the tables to the pivot table, I am left with filters that are only Row and Column and it uses random pieces of information in the pivot table and not the headings that are on the tables. Anybody know of how to fix this?