I want to create a pivot table that pulls data from two tabs on a spreadsheet. Both tabs have the exact same header rows; one is just the continuation of the other. Normally, I could just combine them on one tab but one of the tabs has over 1 million rows so combining data from the other tab would make it too large so it has to be split. I've looked all over and can't seem to figure out how to create a pivot table with 2 tabs like this. Everything I've found is for multiple tabs with different headers but since these have the same headers, I can't figure it out. Can anyone help?