Automate an Excel Spreadsheet

(doc1) FY 16 PMO Demand Capture V5 (1) (doc2) CURRENT FY16 MERCHANDISE INITIATIVES - STORE LIST (STORE) (1) Objective: Use information from doc1 to generate doc2. I need to be able to enter data into doc1 that then automatically (or click a button) generates doc2. Both documents already exist, they are just not automated. Data to be transferred from doc1: 1. Column E – ‘Store’ 2. Column G – ‘Project Title’ a. Project Title should only be created once for one month but can be duplicated in another month. 3. Column J – ‘Project Status’ a. Conditional colour formatting; ‘planned’ = Orange Tile & ‘confirmed’ = Green Tile 4. Column L – ‘Planned Month’