Populate Room Data sheet for MEP equipment

Hi everyone,

I have asked to populate a room date sheet for MEP quantities for each space in my projects. In the other word, I need to count all different Fire, Mechanical, Electrical and Hydraulic equipment in each room/space. I know that I can count different category (for instance: Air terminals) for each space using schedule, but I need to create so many schedule.
I try to find a quicker way as it takes a lot of time in big projects, but unfortunately haven’t been successful. Every thing that I tried, I still miss some of categories.
I’m just wondering is any one knows a quicker way. I really appreciate that if you share it or give me a guide.

Thank you so much.