Automatically create a date wise database

Hello everyone,

I was creating a costing sheet for my small business and want some help related to it.

I'm attaching a sample file for reference.

The prices of raw materials used in our products change on a daily basis. So, I want to create a date-wise database of the costing of our products.

When I update the prices in the "Raw Material" sheet, the costing of finished products is automatically updated in the "costing" sheet.

Now I want to store this updated cost on a daily basis in the "data" worksheet automatically.

Can anyone help me with this?

Thank you.