Cross Linking cells in 2 worksheets.

please check attachment.

Change Q column value for the filled rows to Pending or Dead. Check results. I do not get any error in the attached file.

The file has some changes from originally posted:
- "Delivered " is the dropdown changed to "Delivered"
- formulas in B column sheets("Pending") and sheets("Dead") deleted, they will have the same value that was assigned to the particular line on sheets("Delivered")
- though dropdowns on Pending and Dead sheets have three options the code will fire up only for Delivered on both of them