Order form consolidation

I have closet manufacturing company that II need to create an order form for. I deal with multiple different closets within a house from foyer coat closets to high-end walk-in closets. I need an excel workbook that will consolidate all the things that need ordering from the other sheets that I put the information on from each specific closet. These things include: color of closet, accessories and their finishes, doors and drawers, etc. Let me know if anyone can help.