Exce/VBA - Data from a cell into a specific place in another cell which already

General information for the business: Translating product information into HTML templates.
Kind of development: New program from scratch
Description of requirements/functionality: I have medium to large sized spreadsheet of about 500 rows, each containing product information where each row represents a separate product. There is the basic information like, title, image URL, main description, bullet point description (1,2,3 etc) as separate columns.

The data in this sheet needs to be entered into a website page - I already have prepared the bare bones of the HTML template, all that's left to fill in is the product information in its respective positions in the template. I will supply the HTML template code to the programmer.

Of course, copying and pasting each piece of information into the template will take weeks and I've thought of a few ideas, but hit a wall when I remind myself the data will be unique for each cell, that is, for each template!

The HTML code will also be in a cell in the same spreadsheet so it's all within Excel.

So, I need to 'inject' the title, product URL, description columns 1 to 5 in specific places within the HTML code.

I will supply the first batch of product data so it can be tested with the HTML code output. There will be many more thousands to do, so I need something robust to allow me to use independently in the future.

I should also add the the output should be able to be copied and pasted into another file (I tried one particular method in the past where this strangely wasn't possible).

Here is an example of what the HTML template might looks like. This code will go into one of the cells, and the information from the spreadsheet (which is held in their respective columns) will be injected into the right places in the HTML code. So once the program has run, the output should have the template will all the required information.

EDIT *Please contact me and I will send the template you will be working with.

OS requirements: Windows, Mac OS
Extra notes: