Build an inventory tracking Excel workbook with integrated dashboard

I need an inventory tacking Excel doc that can integrate existing inventory and sales data to provide metrics or inventory and sales performance. The key criteria here is by purchase order level. Excel doc must look professional and aesthetically pleasing. I would also prefer a dashboard of sorts to display KPIs.