Query Database based on List in Excel

[Rob]

I have a need for our business customers to be able to insert a list of customers then chart their performance. The data is stored in SQL Server. I would like for them to be able to paste a list of customers into the spreadsheet and then use that list in my database query. There are about 8000 customers and most of the lists would have about 100 of the customers.

An example would be them pasting a list like this into Sheet 1
company AB
company 12
Company XY

I would want my query to look like this
select month, sum(sales_amount) from CompanySales where Company_Name in (company ABC, company 123, Company XYZ) group by month

Then I could create an Excel chart on the returned data. Is there any way to do this or would this have to be done with some kind of filter

Thanks
Ro