populating data from another sheet

[safisam]

Hi there,

I have 2 sheets, one we created (Sheet A) and another comes from the factory (Sheet B). The info from the factory complete the info on our form. The 2 sheets share one common number, which is the PO number (purchase order number).

Here what I want help with. I want Sheet A to go to a specific place on the Hard disk and locate sheet B, open it and then pickup all new PO numbers from sheet A and find them in Sheet B and then copy several cells from sheet B to Sheet A (for example, build date, packaging date, shipping date ....etc, info I get from the manufacturing), and place those info in sheet A.

If these information has already been populated then ignore those PO's. sometimes the info from the manufacturing is not available for several weeks, so Sheet A will keep checking until this info is available.

Thank you in advance for your help.
Sam

[safisam]

Dears, anyone has an answer? Appreciate your help. Thanks