For Loop - To count shipping containers per week

Hi all,

I've been coming up with blanks on this issue for weeks, I simply do not know how to solve it. I am attaching a sample sheet for reference on what I am dealing with. We get this massive report once a week and we need to do a forecast based on weeks Column "S" per vendor per port of loading per destination per container type. So in this example the final solution would look like what is listed in sheet 1. I was thinking of using some variation of the for each loop to run through all the lines in the report and generate a table like in sheet 1, but I can't figure out the formula to get this done correctly.

The challenge which I keep facing is on week 15 Beijiao -> Perris -> ONEY. The containers that moved is 8, and that is because on column "P" line 189 - 191 has the same ref file # but it repeats so that is still counted as 1 even though it is listed 3 times. However same week but with COSU they run sequentially so its 20 even though the REF File is the same as the containers move up in numbers and don't repeat as 001.

Any ideas on how to tackle this or such?