Van stock management excel sheet

We need a multi-tab Excel or Google Sheets system to manage van stock, material usage, and restocking across 5–10 mobile traders. Each trader must have a separate tab.

The system must include:
Van Stock Tabs:

One van stock tab per trader

Expected quantity vs current stock

"Used This Week" tracking

Automatic "Restock Needed" flags

Cost per item and calculated weekly cost per trader

Supplier link for each material (optional column with URL to Screwfix/Toolstation)

Usage Log:

Combined Usage Log tab (filled from daily WhatsApp messages)

Columns: Date, Trader, Job ID (optional), Materials Used

Weekly Summary:

Weekly Summary tab showing:

Total materials used per trader

Weekly material costs

Items needing restock

Dashboard Tab:

Overview of all low stock items across all traders

Weekly usage report per trader

Visual alerts for shortages and restocking priorities

Total material cost per week per trader

Color-coded formatting for visibility

Monthly Summary:

Monthly usage totals per trader

Total cost of materials per trader

Most used items per trader each month

Archiving & Reset Functionality:

Ability to reset "Used This Week" every Monday (manually or via button)

Archive tab or export system to save each week’s summary for future reference

Option to refill/recover previous week’s data if needed

Structure & Formatting:

Easy-to-duplicate trader tabs for future team expansion

Protected formulas and locked layout to prevent accidental edits

Google Sheets compatible (no Excel-only features or macros)

Please let us know your availability