Spreadsheet automation (the base is already done)

This is a spreadsheet that I already have done some macros to automate it, so I believe that most of the work is already done. Objective: to automate even more and to fix bugs How does it work: I have a program that updates the financial information of the companies I want, then I run a macro to copy the data in value in the sheet "Model", and finally I have the output in the Sheet "Cover". Problems:(i) I created the "BBG" sheet because the "WIRE" stopped calculating the formulas, so would be nice to have "WIRE" working again; (ii) In "WIRE" I would like to fill the error cells in the formula (N/A, #N/A N/A) with the previous formula (I´ve done manually in a couple cells), which should be easy to do; (iii) It´s hard to add a new stock in the spreadsheet, so I´d like something to make it easier. I think the easier way is to insert the stock ticker and the sector (e.g. yellow filled cells in the "WIRE", such as "Brazilian Financials"), and then the macro insert the information in the right spot. It´s important to be easy to add new sectors and that it works with the table in the "Cover" sheet. Would be nice to automate the table on the right side of the "cover" sheet as I add new stocks or Industries. The reset inputs should keep working as well.