excel data tracker

Job ID: 37055327

Budget: $30 – $250 USD

I need an excel data tracker that can track sales data from the data within the workbook and be able to create an invoice. The tracker also keeps inventory records. I have created most of this but the invoice part is where I am stuck. Here is what I have done...(and #4 and maybe #5 is what I need help with)
1 - entered producs in the product worksheet
2 - I will enter the inventory in and out on the orders and inventory worksheet
3 - the Invoice Data worksheet auto populates items from step 2 and I have highlighted in yellow what data needs to be entered (customer information)
4 The invoice. This is where I am stuck. I don't need to save invoices. I just want to create one when needed by simply entering the invoice # on the last workbook (Invoice)
5 The report - I'd like for it to work. It came with the inventory template.
I am not married to any of the appearance or the way it works.
Related categories: Excel Copy Typing