Multiply cells in two worksheets conidtion is matched and use of looping

Hello friends,
There are two worksheets in the attached workbook ("CDL" and "ID"). When there is a match between a cell in column A of "CDL" and a cell in column A of "ID", I want to multiply for the same row, column D of "ID" multiplied with column E of "CDL" till the end of data in "CDL". The multiplication result should be in column G of "CDL". Can you please help? Thank you.

Best regards,
Tahir