Find and Replace text issues - need vb code

Hi,

I have a spreadsheet with 3 sheets.
Sheet one is a list of products
sheet 2 pulls 5 random products from sheet 1 and sheet 3 is a list of html code over 208 lines.

an example of sheet 3 and a row of code:-


What i have is a button that allows me to select 5 products off sheet one and the information associated with that row and then pastes that into sheet 2 and arranges data as i need it and does some calculations.
all of this works fine using macros that i have made.

i now need to replace to part of text from sheet three code with data from a specific cell. i want a button that will run through all the code identifying key specific words and replacing them with data from cells on sheet 2.
So Button_Link_2 will be replaced with data from sheet 2 cell c2. this data will obviously change each time i select 5 different products. so using a macro to find and replace will not work.
then replace src="./5 Products_files/Image_10.png" with a sheet 2 cell d2.

Is there a way of doing what i am after rather than have to go through and find and replace over 40 different changes.

Thanks in advance.

I think an easier way than doing replacements in your actual code would be to use a sheet in your workbook to list the formulas/Values to use, and change that sheet as the need arises. Your code would be able to change the values as needed and use them as needed.