Yes I have some more questions:

1. Do you want one Transfers sheet and one product overview sheet for each six-month period or only one of each sheet for a full year.

2. Do you want to have data/report for more than one year in the same file.

3. B1:E29 in sheet Transfers - is that to be understood as one invoice. Similar question for ranges starting at B32, B63, B94, B125 etc. up to the one starting at N156.

4. You wrote:
That would be ok to have an additional column for invoice number and make all of admiral one contiguous range.

What about having all invoices (up to CHURCH TRANSFER 6) in one contiguous range?
Can you accept having 'TO' in one column (as for example column C) and 'FROM' in the column just to the right instead of having just one 'FROM' as heading?

5. Is invoice date irrelevant (in this context)?

More questions may appear later, but if you answer the above I will be able to start.