macro to create copy of template based on two criteria and paste data from master sheet

I have a master sheet which contains several line items and 4 deal templates. I want a macro to loop therough each line item in master sheet and create copy of 1 of the 4 templates depending upon 2 conditions ie asset type and trensaction type ie buy or sell.

Any help is really appreciated.