Search multiple sheets for value based on criteria and copy data accordingly

[Zagadka]

Want help in writing macro for my project....

In sample sheet provided, following is to be done

if "PND QTY" column in "WIP" sheet has a value of 0, then search its corresponding "MO NO" value in sheets named "JAN-12", "FEB-12" and "MAR-12"

if the particular "MO NO" value is found then look for its corresponding "STATUS" whether it is "C" or not.

IF the value is "C" (there will only be one unique entry for MO NO and with "C" status in all the sheets) then copy "START DATE" and "REQ DATE" next to the "C" Status entry.

After this is done, delete the line in "WIP" sheet where the "PND QTY" was found to be 0.

There could be multiple 0 entries updated to WIP sheet. It should work for all entries when the "Update" button is clicked.

[Zagadka]

Is there nobody who could help me with this code?

Please let me know if anything is not clear in my request.

[Zagadka]

ah well...never mind..i kinda figured it out for myself...