Excel Automation Help needed

In the beginning the sheet will have the following tabs Index - Manually created Introduction - manually created GO/NO GO Checklist - Manually Created Master Server List - Manually populated ( have marked columns that are mandatory to fill up in Grey. If these columns are not populated then there will be an error in generating run books ) Migration Methodology - Will have the list of all Migration Methods and will also have provision to add a new method List - Will be a hidden list which has all the Migration methods Migration Methodology Steps - Will have steps for each migration method Requirement 1 : generate Run Book ================================ STEP 1 : User fills up mandatory columns in Master Server List STEP 2 : User selects Migration Methodology from Master Server List STEP 3: User hits the button generate run book Expected output : This should generate detailed run books as shown in the sample sheet Wave#1 Group 0 Wave#1 Group 1 Wave#1 Group 2 Wave#2 Group 1 The Wave number comes from master server list and the Group number also comes from Master Server List The rows highlighted in Grey in the Detailed runbooks will remain exactly the same and will not change. The steps will be populated for each server in the Group. In the sample sheet there are 2 servers in each group but there may be more servers in the group. Also there may be multiple waves so the tab needs to be named accordingly. Requirement 2 : ============== Assume there is a new Migration method in the market and we want to add this in the Excel. Step 1 : User appends the migration method in Migration Methodology Steps Tab Step 2 : User goes to the tab Migration Methodology and clicks on the button Add methodology Expected outcome The list in the Migration Methodology should be updated to reflect the new method User should be able to generate run book based on this methodology