Excel tabel

Hello,

I need help building a tracking table.

I have a few tables that should be connected:

Table 1 - BOM: Bill of Materials for each item that I sell, with cost and sell price per material.

Table 2 - Price: List of approximately 250 unique items with cost and sell price columns.

Table 3 - Production: recived daily via email in excel, updated every day with the names of items that are starting production and will be sold.

In the end, I want to create a tracking cost table for each item. I receive Table 3 every day with the new items that are sent to production.

Do you have any ideas on how to do this?