Find lowest and the highest values across the sheets and enter into cell

jindon, the Week sheet still doesn't work. BTW, your attached file did not have any code for the Week sheet, so I copied it from your previous post, then changed the relevant lines per your last instruction.