There is a better way to handle this than duplicating your checklist across twelve monthly sheets, and it starts with rethinking what those sheets are for. The question you're asking is practical, and it points to a deeper issue: you don't need twelve separate copies of the same data. You need one source of truth that updates everywhere at once, with the ability to reset or archive each month without losing history.
Your current setup, twelve sheets for twelve months, works until it doesn't. You edit one sheet, then have to remember to update the others. Or you update the current month, but the next month's sheet still shows last month's stock levels and expiry dates. That's not a spreadsheet problem; that's a structure problem. The solution is to keep your data in one place, then use that data to generate your monthly views. A single table for your medications, quantities, and expiry dates can feed every month's checklist. When you update a stock level or change an expiry date, every month that references that item reflects the change instantly. If you need a fresh start for the next month, you don't copy the sheet; you create a view that filters by month, or you duplicate the structure but link the item details back to your master list.
What you lose in duplicate tabs, you gain in accuracy and time. You stop asking "which sheet is current?" and start asking "what does the data say?" That's the shift that matters here. It's not about making your spreadsheet fancier; it's about making it honest. The same logic applies to your repeat cycle. You said you want to edit data in one sheet and have it populate subsequent ones, then repeat again. That's exactly what a master data table enables. You log a change once, and every month that needs that information gets it. When the month rolls over, you don't scramble to update twelve places; you just enter new stock counts and expiry dates into your central list, and your monthly views follow.
The takeaway is straightforward: stop building a workbook that forces you to maintain the same information over and over. Build one that lets the data do the work. You'll spend less time copying and pasting, and more time confident that what you're looking at is actually current. That's the kind of efficiency that matters when you're managing medications and stock for an ambulance, where accuracy isn't just convenient; it's essential.