Extracting data in multiple tabs

[sgallu]

Hi all,

I have a budget workbook with 40 tabs, each laid out identically. Column A list the type of expense (rent, salaries, etc), and column B has the total expenses for the year.

I want to have a new tab set up to summarize the data by tab. So Column a wolud be the same, column B would include the data for the marketing team 1, column be could contain data for operations, and so on, until the 41st column has a sum of the tabs.

It's a similar concept to a pivot table, only that the data is in multiple tables.

Any thoughts or help would be greatly appreciated!!

 

[Robert Mika]

Excel Workbook
	A	B	C	D
1	Totals	Marketing	EXS	HR
2	Salary	200	258	0
3	Exp	0	0	0
4	Rent
5	Elect
Summary