On second thought I find it somewhat unfair to back out of a thread I have already involved myself in, so I decided that I will try to help you out in spite of what I wrote in #8.

Questions/comments

1. Am I right that you enter your data into Sheet Transfers, and that you want formulas to complete sheet July 17 (just to be completely sure).

2. When you name a sheet July 17 does that mean that you have/want one such sheet per day.

3. Please tell me detailed about sheet Transfers (for example):
B1:E29 - is that to be understood as one invoice.
Shoudn't there be entered a date.
Should it be possible to distinguish between Admiral Transfer 1, Admiral Transfer 2 etc.
Would it be acceptable to have all info in B2:E(x) that is in one contiguous range instead of in 18 non-contiguous ranges maybe with extra columns for invoice number, (date perhaps) and the present text in the yellow areas.

Furthermore - regarding the last file you uploaded I understand all the numbers in sheet July 17 from B3 and diagonally down to M14, but I don't understand from where you get the numbers above and below that diagonal. (For example B8, I don't see AYYY TONNNY!!! To Nelson (only from Admiral).

The better you explain the greater the chance that I will be able to help you.