Excel automation

We need the an excel sheet (Target-sheet-v2) to be created from various input located in the 4 sheets (Testsheet, Output-sheet, Code-dictionary, Feature-dictionary) within a excel file. This is because the target output of this automation will be fed to an application which can only take sheet with specific format.
ATTACHMENT