In excel I have entered customer orders, each on a separate worksheet.  I want
to collect the address on each worksheet and display them as a list in
excel or in word. I'm using excel x for mac.

---

Request for Question Clarification by maniac-ga on 21 Sep 2006 16:20 PDT

Hello Lydialydia,

If the address is in the same location on each sheet, its pretty
straight forward to build a macro to collect the addresses and build
the list you are looking for. If you provide the location (one cell or
more than one) for each address & how the sheets are organized (one
file or several), I can provide a macro to collect the addresses for
you.

  --Maniac

I had a similar situation a few years ago....Unfortunately I don't
recall the exact formulas....Research "Piviot-Tables"...Good
Luck.....Rob :)