The data I have collected is huge and varied and makes more sense to keep in one workbook and assigning tabs to certain data (very useful for trending information). I have had a request to extract information that happens to be on three of the 10 worksheets. Short of cutting and pasting it on a new sheet, I thought I might be able to figure out a way to create a pivot table that will consolidate parts of these pages. What special cases allow this to happen? Thanks.