Requirements: use macros to complete the following tasks. Create four different macros to accomplish: $1)$ transfer the data; $2)$ format the data & perform the analysis; $3)$ generate a graph; $4)$ clear all contents$2$Detailed Instructions:$3$a$.$ Insert a comment and include your names$)$ at the beginning of the module.b$.$ Transfer the information from each regional sales record worksheet to the "Consolidate" worksheet. Sales numbers$4$should be inserted into corresponding positions$5$ c$.$ Boldface the title row $($B$3$:E$3)6$ d$.$ In A$16,$ insert the label "Sum" and calculate the sum of sales for each region.e$.$ Using the area A$3$:$15,$ generate a bar chart.f$.$ Clear all contents.g$.$ Insert four different buttons and assign each macro to the corresponding button.