VBA - Copy data into new worksheet

Hi,

In OR sheet, I would like to copy column D, E, F & G to Report sheet if C equal to "DZ". 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 sheet
Column 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!