I'm looking to create a formula which will populate the next delivery date and time base on a set of conditions.

Details:
Worksheet 1 contains a listing of scheduled incoming containers, each with a unique container number, port of entry, delivery date, and time.

Worksheet 2 is a worksheet used to track containers incoming to the facility. Columns include status, a unique container reference number, and port of entry.

Need:
Once the container's status changes to "Complete" on worksheet2, the formula needs to match the completed container with an incoming scheduled container.

Caveats: Containers must go back to the same port they originated from. Also, the next delivery date should reflect the next date and time based on the current date and time (meaning cannot be in the past), as there can be multiple containers scheduled to come in, the same day/week.

Attached are images of worksheet 1 & 2 for reference.Worksheet 1.JPG Worksheet 2.JPG

Thanks in advance for any advice or suggestions you might have!