Hi All,
I have a new web application that outputs to an Excel workbook, problem is that it creates a new sheet for each department, which ends up being over 50 sheets, so I can either print 50 sheets or copy and paste each sheet onto 1 sheet. So my question, and I know it can be done, just don't know how......each sheet has the same title 3 rows and the data starts after that, also some sheets have 1 employee and some have 40 employees. So what I want to do is have it go through all the sheets grab the data and put it into 1 sheet that I can then sort by alphabetical. I would appreciate any help on this.


Thanks,
Lenny