The best solution may not be the one you're looking for in this case. Take a step back and consider the future of the workbook and what will happen with more data being added as time goes on. Your formula works for the present state of the workbook, but will it hold up with updates and be easy to manage?
You might consider consolidating similar data in 1 sheet. It may take some re-structuring, but it would be much easier to analyze and maintain. This might be the best option without access to VSTACK.