Excel/VBA Specialist to Fix and Harden Production Stock Workbook

I run a small UK food manufacturing business and have an existing Excel workbook that manages:

Daily production logging

Frozen & chilled stock

Inventory movements ledger

Simple backlog / buffer planning

The workbook already exists with tables, formulas and some VBA macros, but it needs:

Debugging and stabilising (remove errors, type mismatches, fragile logic)

Clean, reliable daily posting macro (production → stock ledger)

Hardened structure so staff can use it safely

Clear documentation of how to run it each day

Scope is refactor + fix, not build from scratch.

Requirements:

Strong Excel + VBA experience

Comfortable with manufacturing / stock logic

Mac-compatible Excel (important)

This is a short project (1–3 days).
Goal is a stable, reliable production & inventory workbook I can hand to my team.