Bulk Edit and Rename 50 HTML Files

I have 50 html files that need to be edited and renamed. I will provide a spreadsheet that shows the old and new data for each file. For example: Old Product Name: Product XYZ Old File Name: [login to view URL] New Product Name: Product 123 New File Name: [login to view URL] Within each file, you will need to make the relevant changes. The changes will be made in the same area of each file. For example, change every instance of “XYZ” to “123” within the source code. The real data will be different for each html file, and will be listed in the spreadsheet. There is another edit that will be exactly the same for each file. You will need to delete a section of code and replace it. I will provide the before an after code. There is a separate html file that links to all 50 of the others. The links on this page must be updated to the new file names.