Something else you should consider with that much data.



Solution using MS ACCESS

If all the column  names are the same in each sheet, import them into MS
Access.

Then Run a query over the data with the criteria as follows:

City_Type IN("City1", "City2", "City3"...) OR

City_Type IN("City1", "City2", "City3"...) AND Fare_Type in("X", "Y".)