VBA code to help manage a list of information

Please check the attached file. The description references to it: So this workbook is used to track a range of indicators The 'DEC' sheet, is used to note indicators and data from external sources i.e. note taking It's a hierarchy structure: cluster, factor, indicators, and data Columns A:L are used to rank the indicators with data The REBUILD reorders the structure in A:L so the rank is preserved after adding / removing rows This is then sources both in the 'REC' sheet (recomposition) And the INDAC (indicators) sheet REC is a list of live indicators in INDAC, and the list of indicators from DEC Live indicators are static entries There is some rough code to highlight when an indicator needs to be added / removed which is self-explanatory The INDAC sheet has the list of indicators from REC, from the static values Column C is an input column for comments on the indicator Columns D:F grab historic data from DEC, again the code is self-explanatory Note the number of historic columns can vary i.e. at the moment there is 3Q15 and 2Q15. There could be 1Q15 and so on. There are hidden columns with data fields and a NOTES area Each indicator has by default 41 rows including the header The FWD and RWD buttons cycle through the indicators for ease of review The MAKE button runs a macro to create the indicator tables (with 41 rows) REQUIREMENT From time to time I will want to add and remove indicators I want a macro that will insert the indicator at the right ranking I.e. at the moment in the REC sheet there is 3 indicators to add So the script should add the number of rows, add the default table (as MAKE does) and preserve the existing notes/data in the other indicator tables Also if I remove an indicator, it should deleted the rows attached to that indicator, plus any objects (if easily possible - no big deal if not) while preserving the other indicators I am not interested in any formatting changes etc., just the code to perform the requirement please This project will suit someone that has experience with managing data in Excel, particularly data that can be structured as a list Feel free to ask questions so you get comfort with the requirement and the structure of source Many thanks