I have data in a pivot table which I need to get into a specifically formatted spreadsheet. I have used the simple =Sheet3!E5 formula for all of the cells, however, the spreadsheet is ever changing -adding rows and losing rows from the pivot as data changes. I don't know how to capture the increases and decreases in the final spreadsheet. Any help would be appreciated.