Take a look at the For Each Loop container.   You'll need to set up a number of package variables to handle things like the varying names of the spreadsheets, and you can probably create a stored procedure to handle the query for each customer based on the customer id value.   You can generate those as the query that sustains the For Each Loop container.