Newtonboy,

Your master sheet for incoming logs seems OK in design. Maybe you could
consider adding a column with the Acquisition Date.

As to your shipments:
First of all, if you have the log id's in a column in the port sheet,
the VLOOKUP() function can be used to bring any information from the
master sheet. Assuming the id's are in column A:A and that similarly
your log data in master sheet start from column A:A (which contains the
id's), then in the port sheet you can use the formula:
=VLOOKUP(A2, 'Sheet1'!A:F, number, 0)
Change the name Sheet1 to whatever the name of your sheet. The 3rd
argument, number, is the number of the column in the source list. Thus,
if diameter is in column B:B, number is 2 (2nd column).

Does this help?
Kostis Vezerides