How about keeping all the data in one sheet (be a lot easier) and filter the pivot by the dates you want? I think that can be easily done though admittedly I don't use pivot tables much. Let me see if I can work something up for us to look at.