I have attached two workbooks. What I would like to attempt to do is in the September PO's workbook is take the dollar amount in the cell adjacent to the word total in each tab except for the master template and add them together. Then I would like the sum of all of the totals of each individual tab to show up in the shop supplies workbook for the 7090 PO code under the the month of september. I would like for this to be automatic so whenever a new tab is inserted into the 7090 september PO's workbook it totals all of the tabs in the shop supplies workbook in the correct location so that I don't have to open both workbooks and total each tab and physically go into the shop supplies workbook and enter the total in. Please let me know if this is possible.
Bookmarks