Automated Excel Scaffold Billing Spreadsheet

I need an Excel-based workbook that lets me type a scaffold tag in once and have everything else spring to life automatically. As soon as I enter or edit a tag, the file must:

• Pull the associated material list and roll the counts into overall yard balances.
• Issue a unique, sequential tag number if one is not already assigned.
• Start a 28-day billing clock, post the recurring charges on schedule, and stop that clock the moment I mark the tag as dismantled.
• Produce the final invoice for that tag, zero it out of active inventory, and leave a clean audit trail.

All yard totals, billing summaries, and aging reports should stay current without manual refreshes. I also want a simple dashboard that shows what is on rent, what is due for billing this cycle, and what has been dismantled but not yet invoiced.

The workbook must be formula-driven or macro-driven (your call), but everything has to run inside standard Excel—no external add-ins—so my crew can use it on any company laptop. If you have built something similar, show me a quick demo sheet and outline the structure you plan to use. Accuracy, clean code, and ease of use are my top priorities; if I can trust the numbers, I can focus on the job site instead of the keyboard.

I have the base laid out, just need help to refine it and have proper formulas entered