Love your site and every single course I have downloaded.  I recently downloaded excel expert 1 to get information on summary sheets in excel.  Question...is there a way of not really summarizing the data from sheets but from collecting all of the data from the sheets and listing them all on one sheet?  I have a workbook that is broken down into different departments that our staff works in.  I would like to add a page that has every employee listed alphabetically and not just summarize the data.  Would that be a macro?

---

Reply from Richard Rost:

Give me an example of how your sheets are set up so I can understand your question better.