Automated Excel Stock Register with Summary for Garment Manufacturing

I need an automated Excel-based stock register tailored for a garment manufacturing company. The register should manage raw materials, finished goods, and job work processes. It must include a summary with automated calculations and dynamically update changes across sheets when selecting products with different sizes. It should also track materials sent for stitching (including packing materials), record items received back after stitching, and manage sales of finished goods. The solution should be user-friendly and efficient for inventory management.