Sheet#5, maybe you need to change the layout and make it pivot table to count the rescheduled due to code brown and the cancelled due to code brown + add the total and the percentage. May the table layout ready for the whole Oct. I need also a chart for

Sheet#5, maybe you need to change the layout and make it pivot table to count the rescheduled due to code brown and the cancelled due to code brown + add the total and the percentage. May the table layout ready for the whole Oct. I need also a chart for this sheet with linear to see the departments that have cancelled or rescheduled due to code brown

In All data in one sheet:

Gather all the sheets from Inpatient sheet to ER sheet in this sheet and make it ready for the whole month of Oct. Feel free to change the layout of the table and to use pivot table

For each individual sheet add the Total and the percentage see the screenshot as an example