Creating tabs with predefined name and filling with predefined content macro needed

Hello,

I have no knowledge in VBA programming whatsoever, but I know my task requires a macro to work properly.

I have a list of unique items for sale (Column D) with possible upgrades and bunch of other information for other reports (left blank with no headings). For each item I need separate tab, named as item name (important!) to prepare a written contract.

I have prepared template with required contract information.

So what I’d like macro do to, is to create number of tabs with names as item name (yes, I know I’m repeating myself), populate it with template from “Pre-defined content” tab and add “item name” in cell B15 of each created tab to make vlookups working.

I know that there are some smart people here which had more time to spend on learning that stuff. So if someone would be such generous to make my task complete I’d be really obliged.

Please see file attached
Sales contracts - test.xlsm

Thanks,
yidam

Could anyone even tell me if that task is possible to perform?