The way the data is laid down in the spreadsheets is not very efficient for retrieval based on filtering criteria, but I assume is the data you have. It would probably be worth considering a format change to make filtering and extracting data much more simpler.
Excel works very well with tables, but it is not as good when working with disperse values. And what you have now are disperse values. Everything can be done, it is simply much harder to do with this format.
MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.