Hardware schedule question

[Ian_H]

I am trying to create a rather robust hardware schedule to help simplify life for our estimators. What I keep coming back to is trying to reference a key schedule within a key schedule but it appears you can't do that. 

Ultimately I would like to create a key schedule of all of the devices (see image below), then create another schedule where I can assign the devices to a hardware set type (similar to image 2). I could then assign the hardware set type to a door and all of the other information would then be attached to that door so we could get counts. We could also use the schedules on our sheets as shown below. 

I could probably do it all in one key schedule, but the length of parameters in the door properties window would be really long.

Any thoughts or recommendations? It seems like something that could perhaps be accomplished in Dynamo, but my skills are still at the beginners level using that program. 

See the screenshot below of how we currently are showing the hardware schedule, but the person that put it together just used grouped texts. 

Thanks

[ToanDN]

You need to do it in one Key Schedule since Revit have not implemented referencing a key from a key schedule as a parameter in another key schedule.  Below is an example from my project.  I don't show Description for hardware items because they are in specs but it can certainly be done.