Best way to organize a pipeline?

Hi all, I work in sales and I use excel 2010 to keep track of my sales pipeline (what deals I am currently working on). I'll set the situation up so you can actually understand the problem and maybe impart some wisdom on me.

The situation
I have 2 sheets in my workbook. Sheet1 is dynamic, and called Pipeline, and Sheet2 is static and called ClientInfo. The Pipeline sheet changes multiple times a day with current deals that I am working on for my clients, and ClientInfo has the static account information in it like company names, and contacts.

I have another program that tells me what new quotes I have in our system. It let's me export to excel so I have it return the account number, the size of the deal, and the deal number to a workbook called OpenQuotes.

I copy that information from OpenQuotes, and paste it into the left 3 columns of my Pipeline sheet. (A1) Account number, (B1) Deal size, (C1) Deal number. To the right of that, I use VLOOKUP and reference (A1) against my ClientInfo sheet to populate the corresponding company name, and contact information.

At the end of the day, my Pipeline sheet looks like this:
(A1) Account number, (B1) Deal size, (C1) Deal number, (D1) Company Name, (E1) Contact Name, (F1) Email Address, (G1) Phone Number

The problem(s)
My accounts have more than one contact person, and the proper contact person changes depending on who I am working with on each particular deal.

So if I had 6 contacts at XYZ Corp, Inc, all of a sudden my Pipeline sheet is not stopping at (G1), it's going all the way out to (AA1). Way too much scrolling when the idea is to quickly glance at the sheet and know who I need to call for each deal.

The second problem is that I have multiple accounts, and the deals are always being removed, added, or changed on a daily basis, so I can't figure out a formula to accommodate that.

The solution?
Ideally what I'd like to do is copy and paste the 3 fields from from OpenQuotes to Pipeline, have vlookup populate (D1) with the name as usual, and (E1) with a drop down for that particular account number, pick the correct contact name for the deal, and have that return the chosen name's corresponding email address and phone number.

For example, it might look like this at the end:

(A1) 1001 (B1) $10,000 (C1) QN2222 (D1) XYZ Corp, Inc (E1) <drop-down list of only XYZ names from ClientInfo sheet> Joe Dale (F1) <result based on (E1)> joe.dale@xyzcorp.com (G1) <result based on (E1)> 800-555-5555 ext 1234
(A2) 1002 (B2) $65,000 (C2) QN2453 (D2) ABC Corp, Inc (E2) <drop-down list of only ABC names from ClientInfo sheet> Sam Farr (F2) <result based on (E2)> sam.farr@abccorp.com (G2) <result based on (E2)>800-666-6666 ext 4321

How can I accomplish this?

Thanks very much