Excel Formula for Inventory Tables

I need an Excel expert to create a formula that relates two product inventory tables in a many-to-many relationship. The output should provide a total quantity of products, segregated by product category.

Requirements:
- Create a dynamic formula to link two tables.
- Accurately calculate total quantity.
- Segregate totals by product category.

Ideal Skills:
- Proficiency in Excel, especially with complex formulas and table relationships.
- Experience with inventory management data.
- Strong analytical skills to ensure accuracy in calculations.