Summarizing Information on Select Tabs

[GIJOE1980]

I am able to summarize similar information across all tabs which are identified as Project 1 - 34. Each project has its own tab. On each tab the columns are identified as months and the rows are revenue and expense accounts. Each project falls under one of eight departments. I don't know how to use the department ID in the formula that I use to summarize each dept.

Any ideas?

 

[General Ledger]

What formula are you using? Are you using sum through formulas?

Is the data on each sheet laid out exactly the same? Same rows and columns?

You might want to consider using consolidating PivotTables.