Identify if Value went to 0, blank, or dropped significantly

[wherdzik]

Hi All,
Is this too difficult?

Attached you will find just a 2 sheet example of our large file. Each month we have to review each of the 200 sheets. One of the things that sometimes happens which is simulated in Sheet 2222_Smith is that line 71 identified as Patient Panel becomes blank or drops significantly because something happens to the data source. Most of the time we catch this during our review but sometimes we miss it. I am wondering if there is some sort of a process that I implement that would :

1. Search Each worksheet with the naming standard 12345_Smith. InStr(ws.Name, "_")
2. Find Current Month by looking what is entered in teh Input - Date
3. Search each worksheet if it contains Patient Panel in Column B.
4. Check to see if it contains a value or value dropped by 30 Percent from previous column.
5. Identify the sheet (2) where the value dropped or is 0 via a message box?

Hopefully that makes sense.

Thank you for reading.