Inventory and Order Dashboard

I am looking for a skilled developer to create an inventory and order dashboard for my business. The dashboard should have the following features using EXCEL:

- Real-time inventory tracking: I need to be able to see the current stock levels for all my products at any given time. I will need to be able to use my scan gun to scan products in inventory.
- Order management: The dashboard should allow me to manage incoming orders, track their status, and generate order picklists. Picklist will need to reduce inventory as I scan products out.
- Sales analytics: I would like the dashboard to provide analytics, such as top-selling products, least moving products, etc...

Integration with my existing inventory management system is required. I currently use Smartsheets as my inventory ERP software.

Ideal Skills and Experience:
- Proficiency in dashboard development and data visualization
- Experience with integrating inventory management systems (Using RF Scanners)
- Familiarity with Smart sheets or similar cloud-based software

If you have the necessary skills and experience, please submit your proposal.
What is expected.
Tab01 Inventory:
A) Consisting of SKU Number, QTY IN, QTY OUT, QTY LIVE
B) First scan searches for the match in my inventory list
C) Second Scan will be to input the QTY to enter

Tab02 Picklist Generator:
A) I will input the order number and it will generate the picklist from our Database on separate tabs
B) I will assign part of the picklist to an employee, and it will update the Picklist with name and date
C) I will need to retrieve from database relevant information to complete the Pick list like location, etc...

Note that also Notepads will be used as the interface with the scanner to complete the picklist.