Create a power automate flow, which will update my sharepoint list based on logic below

Hi All,

I have 3 SharePoint lists with alot of data , but I want to do this thing in a power automate flow and run this everyday to give me a ok and not ok status. This way for everything which is Not OK, I can update my slots back again by +1 in SharepointList1.

Below is the diagram of what I am trying to achieve, can someone please help me?