updating other spreadsheets from a Mac pivot table

I am on the counting committee of my church. For the past few months I have been creating a Numbers spreadsheet to semi-automate the counting function. What we do is take the weekly collection, total checks, currency, and coin and create a deposit for the bank. Additionally, we must credit the members with their donations, and categories the special donations received. Eg. Special donations might include money for Altar flowers, outreach, food pantry etc. In order to automate some of the processes, I have created in Numbers the following: Member Acct number Pop-up list, Special Donation Pop-up list. The challenge: On any given Sunday I could have as many as three categories of Special Donations. The spreadsheet allows us to capture member name and account number, type of donation, amount, whether cash or check. By using a pivot table I have been able to capture the total amount of donations for each category we may encounter on given Sunday. The critical part of the process is to create a summary sheet that captures all of the income and identify by various categories. I know how to refresh the pivot table every week, but I don't know how to automatically update the summary sheet from the refreshed pivot table. Originally set it up using a lookup function. Works only until the pivot table is refreshed, then new categories aren't being picked up. Any Suggestions?