In Excel, is there a way of creating a user interface which allows you to
connect to a DSN and return data to Excel based on user input?

In this scenario, there would be many DSN's available but the interface
would take user input (e.g. customer2), connect to the relevant DSN
(customer2), run an SQL Query and return data to Excel.