Macro-based Dashboard

Hi, maybe I'm dense but what you actually want is a button that you press every 20 minutes to show the next 20 minute cycle?
But if you close the file and open it the next day, it will have to fill in all the passed not filled cycles and add the x number of mats and update the dashboard?
There is no check if the actual mats have been produced just that the cycle of 20 minutes has passed and new one must be started?

Have you thought of having a dedicated PC or laptop and an open Excel session that does this automatically every 20 minutes and after the office closes saves the file and closes it?
Open it the next day and it goes on? Something like that?

How's you VBA knowledge an coding experience? This will require maintenance so you will have to get someone crazy enough like us guys to maintain and edit the system for you, makes you independent of forums or third-parties that you'll have to hire

Must've scared you off with my comments.
I did play around with it and I think it does what you want
Will wait for your comment on my first answer and maybe you're curious

At this moment it's 03:20 in Ontario, so you're probably still sleeping.
Hope to hear from you when you start your (work)day (it'll probably be around 16:00 here), we're 06:00 ahead of you
This is what I put together and except for some fine-tuning and the fact that this dos not (yet) consider holidays looks like all you have to is tart Excel and watch the screen while it does it's thing, if all goes well no human interaction necessary

Don't forget to enable macro's, the best is to save the file in a sub folder on your HDD and make that location trusted in the Excel Trust options.
No malware of virus in my code

Curious to hear what you think of this

The file now contains data up to 09:08 so it won't look okay until past that time on your side

Here's the same file but clear of all data so you can start afresh for today

Hi, It seems I made a mistake so the whole thing hangs. Sorry for that.
Corrected my mistake and it should do the trick now.
Hope you at least let me know it works (or not)