Is there one worksheet in each file per customer or multiple customers on each worksheet? It might be useful to see a sample of your data.