help refining lots of data via power query

Hi all,

I've recently started a job in a factory where excel is used as a tool to keep up with how far along the production line every product is. Well, another program is updated and then people like me click through hundreds of pages and update an excel workbook by coloring in cells in green to build a graph of cells. I know for sure this could be automated and way fancier looking as well but I'm pretty new to excel and get stuck. Tinkering with my own data to create a financial logbook with basic formula's and editable categories is all my experience so far.

I've made an example workbook that I'll attach that I hope captures both the data I have (the software used does "dump" all its data to another excel file) and what outcomes I am looking for. If anyone could help with my example workbook that would hopefully give me enough pointers to continue learning myself. I've also requested a training for excel, but first have to do a MS projects training.

The biggest two issues I run into at the moment;
- refining lots of data towards displaying only what I want in the specific way I want it (one step through power query, or do I need multiple steps?)
- showing changes through time. So when the data changes, how can I make excel show the difference between today and last week fi

I find it hard to explain in words so I tried to explain within the workbook example. Thanks in advance for taking a look!

Cheers, Tom