As to:

"Not as critical, but they have two sister companies, with shared salespeople. It would be ideal if each salesperson's report contained two customer lists - one for each company. In Excel this would mean two separate sheets."

This can be accomplished by using the "Tied to this database" option on the Edit Definition tab.

The Workspace would have 2 identical Views ( different names ), with each pointing at the appropriate database.