Hello,

This is my first time posting, so I will try to give as much info as possible, but please let me know if I need to give more.

I have a workbook with 17 spreadsheets in it. The first tab holds all the information from all of my other tabs, and the remaining tabs are for 16 different projects that I am managing.

The project tabs have 11 columns of data that will be listed. I have data for the current year and projected data for the next year split into 2 tables under the 11 column headers. At the bottom of the each table I have a row which sums the totals of the expense columns i.e. =sum(F7:F10) and =sum(F14:F20). And at the bottom of the worksheet I have a row which sums the totals of expenses for each coulmn i.e. =sum(F11+F21).

My "Summary Tab" shows all the data from the other worsheets all together. Although, I know this seems a bit repeatitive, this is how it has to be done. What I would like to do is have my summary tab automatically fill in with the data from the other 16 tabs any time the information on those sheets is changed/added/removed.

Please note that there may be times when rows will have to be added to the tables as the current set up I have may not have enough sapce for all the initiatives that need to be included on the spreadsheet (this is why I created the tables, so that when a new row was inserted, the formulas and formatting would automatically insert in the new row without have to copy and paste).

Also, please note that several people will be updating this workbook, so I want it to function automatically so that other users will not have trouble updating their information. I may need to add additional tabs as well and will need to know how to include news tabs into the automatic update.

Does anyone know if there is a way to do this?

Forum Help.xlsx
I've included a copy of my spreadsheet, althoguh I have removed the data and just inserted some sample info.

Thank you in advance for any help!!