I need advise on how to set up a list of accounts. Currently the account
heading is in a row of merged cells and the rows below hold columns of
information. The amount of rows is always changing as projects are added. I
want to be able to sort the accounts according to site location rather than
alphabetically and back again. There are about 100 accounts each fluctuating
between 1 and 100 projects over a month. How can I include the account
heading and the data in the sort. For example:

Account A Chicago Rep: Jon Smith Billing: Jane Doe
Project # Job# Qty Due to Ship Status
11111 1 50 2/2/08 D
12345 2 75 2/4/08 C

Account B Cincinati Rep: Jon Smith Billing: Jane Doe
Project # Job# Qty Due to Ship Status
22222 4 60 2/3/08 D
45678 8 70 2/10/08 C

Account C Chicago Rep: Jon Smith Billing: Jane Doe
Project # Job# Qty Due to Ship Status
33333 5 55 2/5/08 D
89123 3 80 2/11/08 C

So how do I sort through each account within the entire document to include
all the account data? It is not necessary to sort the data, just the account
headings. I would really appreciate any suggestions. Thanks!