Thanks again for the help.

It's a bit hard to desensitize the information, so I'll try to as best as I'm able with completely made up info. The info that needs to go into the spreadsheet (somehow) is basically as follows:

Region 1:
RM: Jill Litton Phone #: 714-588-6999 E-mail: JillLitton@Jill.com
AM: William Conell, 602-776-4922, WillConn@will.com
SM: Dennis Duff, 888-888-8877, DennisDuff@dennis.com
Site: Random Corp., 330 S. Broadway LA, CA, 788-266-4435
Site: Not Real LLC., 4861 North South St, LA, CA, 788-888-1354
SM: Billy Burns, 435-435-7486, BillyBob@billy.net
Site: AlsoFake Design, 2357 W. Manchester Ave, NY, NY, 326-555-7719

All listed are in Region 1 and in reality there would be a ton more names added to this. In case that's not super clear, Jill is the Regional Manager, William is one of the account managers under her, Dennis and Billy are under William. Dennis is in charge of the two sites listed below him, Billy is in charge of the one below him.

Does that help?