Macro to Copy Values from another Sheet and insert certain # of rows if condition is meet

Hi I just want to know if it is possible to have macro for my excel file. Please see attached "Data.xlsx" for my excel data sample. And please see attached image "Output.jpg". The value in Column D of Sheet2 will be the basis for how many rows will be inserted on the last Name of the same items on Sheet1 and copy values from Column B and C of Sheet2 for the corresponding Code. Thanks you in advance if someone can give me advice on this.

Output.jpg