.. uploaded .. if that is easier than trying to communicate with such an amateur!
I'd rather try to just do it in the forum as the thread will then be more use to future readers as well.
To implement ..
1. With your workbook active press Alt+F11 to bring up the vba window.
2. In the Visual Basic window use the menu to Insert|Module
3. Copy and Paste the code below into the main right hand pane that opens at step 2.
4. Close the Visual Basic window.
5. Press Alt+F8 to bring up the Macro dialog
6. Select the macro & click ‘Run’
7. Your workbook will need to be saved as a macro-enabled workbook (*.xlsm)
Would all sheets need to be the same, except the summary?
Unless there are a lot of them
and they are large
or might still have 'Pending' or whatever you are searching for in column C then it shouldn't matter.
However, if you wanted to exclude them from the code then we need some way to identify either the sheets to process or the sheets to exclude. That could be by where the sheets are (eg exclude the left hand 3 sheets) or what the sheets are called (eg process all sheets whose names start with "data")