VBA - Copy data into new worksheet

You could at least be a little more specific about where goes what.
You make it difficult for others to first search what goes where. YOU know the values but others don't,
I assume that the references in the thumbnail are correct?

Clear, will see if I can help you

What if there are more than one with DZ, do you want to append to an existing reports or do want to clear the report sheet with every query?

Doesn't make sense check your file, I think you mean invoice A and invoice C

I think this whole file doesn't make sense at all so I hope you can explain it before we put precious time into it.
You say you look at the OR contents in Column C for a cell with the value 'DZ', if found the data is copied to the columns you have mentioned in the Reprot worksheet, so far that is clear.
After that you find data in the Invoice sheet but what does it refer to?
There is no relationship between the OR and the Invoice sheet to know/make sure what data to fetch.

Furthermore I was wondering why your file was so big with so little data (at first sight) but that's because you've left a whole lot of data in column G of the Report sheet starting at row 7000 125403 and then again some more starting in Column A-D at row 125404 down to row 126228 in column D
Sloppy !!!
But first, explain more. Not going to work with this.

Yes, that I understood but I see no relationship between the OR and the Invoice worksheet to know which one to select.
THAT is what you nee to explain. How do you know which row in Invoice to select based on the data from the OR worksheet?

The values in Invoice Column C are not found in OR column A, B or E

Guessing is not an option so either the data you have in the sample workbook is incomplete or ....

Then WHY the DZ selection? I do not see any clear relation to that
I like to understand things and see no relation between the value in OR E to what I see in Invoice C
Does it mean that you just want to copy adat and nothing related? Except the document type?

I see wher your explanation goes wrong:
In the first post you said the following: (I added Ste 1 and Step 2 to try an understand)

Step 1: In OR sheet, I would like to copy column D, E, F & G to Report sheet if C equal to "DZ".

Step 2: Then by using column G in Report, find info from Invoice sheet for column H to J in Report.*In Report*Column H = amount for type AO & A8 (85% of tax base amount) in Invoice sheetColumn I = amount for type A1 & A8 (15% of tax base amount) in Invoice sheet
Please take a look at the expected result as attached.
Thank you in advance!

If you read step 2 then you see what I mean you start explaining that you want using Column G in Report find the values but Column G is empty after Step 1
You meant in Column G OR find the corresponding in Invoice Column C THEN it starts making sense.

So you see, if the explanation is correct it's easier to understand and not expect others to assume they understand what you're asking.
But Okay, it's clear. will work on it.

How is you Macro knowledge (VBA?)

Will do my best (explaining), will work on it later today

Okay, this is what I have come up with.
I added quite a few comments in the VBA project for you to read and grasp the idea, hope it helps you.
Coding VBA is possible in many ways as long as the syntax is respected. How it's approached that's entirely personal.
VBA and code is limited only by the person's fantasy
Press the smiley in the OR sheet to trigger the macro and generate the report.
The worksheet Report (2) is your original sample result.

There is quite some inconsistency in YOUR sample (see attachment 'Explanation')
and a modified version of my last solution

I suggest you look at the explanation first and explain the inconsistency

I have given you the help you requested, and yes the modifications can be doen.
I think that if you try and read the code as you would text to see what it does (it's explained in a way in the comments) you could come up with the the solution too.
The difference (if you read the two versions) you will see that it checks if there is already a value in the same cell, it adds it up.
If you want the numbers to be positive, ten all you need to do is make the value ABS (absolute)
I'm off you a long weekend.
Hope you can figure it out, it's good to learn how to code so you do not stay dependent of others

And don't forget, that you altered the report sheet, added an empty column, so well.
You asked, you got an answer.
If you then decide it all has to be modified then, well, my advice is to get someone with some vba knowledge, give him my code (there are of course many other ways others would do it) and build on from that.
Like I said, after the weekdn and if I have time I'll see if understand the changes you want