Automated Stock Update System

I'm looking for a solution to automatically stock taking using a handheld barcode scanner. The scanner should read Code 128 barcodes (e.g., *SKU001-S-BLK*) and update an Excel sheet with the following data: perfect modul vba

- Stock Levels
- Sales Records
- Product Details

The Excel sheet should include:
- Total Stock
- Stock In
- Stock Out
- Remaining Stock
- Rejected Stock

Ideal Skills and Experience:
- Proficiency in Excel
- Experience with barcode scanning technology
- Familiarity with Code 128 barcodes
- Ability to design an automation system that integrates barcode scanning with Excel updates

Please provide examples of similar work done.