Is it possible to make on large pivot table from multiple workbooks that have multiple spreadsheets? I have tried merging ranges but I have so many ranges that it gets all messy in the end. I made a pivot table for each individual spreadsheets but now i have many small pivot tables instead of one large one, which is what I really need. There are around 9 workbooks and each have anywhere between 3 to 20 separate sheets.