I have a workbook that tracks insurance authorizations and the remaining units. Each page has a client listed as their unit are tracked weekly. I want to summarize certain info info a cover sheet so it is easy for me to see when their authorizations are getting low or the due date to renew is coming up. Any advice?

I provided a fictitious exampleAuth Log example.xlsx