Right now I have an excel workbook that holds all of my inventory data. It is seperated into 3 tabs by product category and then further broken down in each tab into individual product, color, and quantity. When we receive an order we record it in our "finances" workbook and then manually subtract the products from our inventory workbook.

I am trying to link the two workbooks. What I want to do is automatically adjust inventory levels based on what I input into the finances workbook. I really am not sure where to start. If anyone needs more information I will try to better explain myself. Thank you