Jumpin' Jehosephat! How can one company have that many account numbers?

Not my business. Anyway I recommend three database on 3 separate sheets, named accordingly.

Main DataBase, AKA Bill To
Account # Company Name Address 1 Address 2 fistname LastNamee Phone Notes
12234 ABC Shop 123 Fake Street STE 204
56769 ABC Shop 123 Fake Street STE 204
Ship To DataBase
Account # Company Name Address 1 Address 2 fistname LastNamee Phone Notes
12234-001 ABC Shop 123 Fake Street STE 204
12234-002 ABC Shop 234 Nexte Street
56769-002 ABC Shop 123 Fake Street STE 204
Price DataBase
Account # Type
012345-000 Normal
012345-001 Government
234567-000 Normal
234567-001 Government
234567-002 Discount
51256-005 Normal
56789-002 Discount

For business advice from a bunch of really nice guys and girls, try this place: BreakTime 3