Update Summary Page based on data entered into 5 other Worksheets
I have an excel spreadsheet that I am using to track contributions given to our Church. I am needing to pull the contribution data from multiple sheets into a Summary page but have not been able to create a formula for doing this successfully. I have 12 different workbooks (1 for each month of the year) that I want to get a monthly summary for each & then eventually pull the data from the 12 monthly summary pages into a yearly summary page.
I am attaching the file from my Dropbox for you to review & let me know the best way to do this.
https://www.dropbox.com/s/v0qxkoqplx745ys/test_input.xlsm?dl=0
Can you help?
I have an excel spreadsheet that I am using to track contributions given to our Church. I am needing to pull the contribution data from multiple sheets into a Summary page but have not been able to create a formula for doing this successfully. I have 12 different workbooks (1 for each month of the year) that I want to get a monthly summary for each & then eventually pull the data from the 12 monthly summary pages into a yearly summary page.
I am attaching the file from my Dropbox for you to review & let me know the best way to do this.
https://www.dropbox.com/s/v0qxkoqplx745ys/test_input.xlsm?dl=0
Can you help?