Excel Macros to create new tab and worksheet with data

1. Tow buttons needed in the tab Res1 with names – AVMO and Joan 2. Clicking on AVMO button should add a tab with the name AVMO and should be of the format same as the sample tab “AVMO” in the attached. It should be added as third tab. I added row 2 as reference for you to tell what should be the source for the data in the fields. It should source data from two tabs – First and the Fifth tab and add all the people. I added rows 3 and 4 manually for reference. 3. Clicking on Joan button should create a new spreadsheet in the folder that this particular sheet is going to sit. It should be named as “Hours report Joan_ <<Month>> <<Year>>”, so for example for this month it should be “Hours report Joan_ September 2019”. Spreadsheet should have two tabs corresponding to first and fifth tab in the attached. Should copy all the data until column T 4. I have programming skills (COBOL etc.,) and I think I can maintain the code. Need the required transition at the end to maintain the code. Also I am going to use this code in a different spreadsheet and I need helping moving this code and executing it in that sheet 5. I need to generate these reports monthly and rows may get added/deleted monthly to this master sheet. 6. Need by 9/29/2019 EOD