Is there anyone who knows how to do the following. Any help would be greatly appreciated!

On Sheet2 Range("A1:A100") is the data

If at any time any cell in the range says "Wait for Order" then

a message box would appear if I am any other sheet saying, Wait for Order

Thanks Josh