Pulling data from list by earliest date

[Harley78]

I am in need of help how to pull data based on soonest date.
I have a worksheet that reflects my inbound shipments that includes agreement number, ETA and Tracking info.. there could be multiple lines of the same agreement number with different ETA dates. I want to pull data that will arrive the soonest to another worksheet.
Can anyone help me understand how to pull this info based earliest delivery?

 

[yky]

Do you have a sample sheet to share?

 

[Harley78]

Do you have a sample sheet to share?

My freight worksheet(directly below) I want to pull the data from this worksheet and have the second sheet (Balance Due Cells AN AO AP updated from from the freight worksheet based on soonest delivery (column J). is it possible?

Balance Due

 

[Harley78]

Okay, got where I can pull the earliest date based on PO#. Formula is =MIN(IF( A222=‘Freight’!B:B,’Freight’!N:N,””)). Now how to attach a vlookup for the quantity and tracking info. Any help is greatly appreciated