Manipulate very large Excel files with advanced filters

Job ID: 34869788

Budget: €30 – €250 EUR

I've a collection of 160 excel files across 51 folders with USA business data across states.
I need this data filtered as follows:
i have a list of 1000 cities
I need a new excel file for each city with list of businesses
Businesses need to be filtered by 30 of the categories from the NAICS column (North American Industry Classification System)
Related categories: Data Processing Data Entry Excel Web Search Data Mining