For a pure formulas-automated play which works to pull in and stack data from
up to 12 identically structured individual sheets (this would be your
individual dept sheets) in a single summary sheet, try this sample from my
archives (nicely rendered, full details inside):

http://www.savefile.com/files/236284
Auto summarize n stack lines from 12 primary sheets.zip

The desired stacking sequence for data from the 12 individual sheets within
the summary sheet can be defined easily. Just ensure that the sheetnames
entered within the summary sheet's R5:AC5 are consistent with those on the
actual sheet tabs, ie match exactly, except for case.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve R" wrote:
I am trying to build a reporting tool where each department enters it's own
information. From that I want it to populate a summary sheet. The summary
sheet has the same column as the data sheet. Is there a way to do this?