use macros to complete the following tasks. Create four different macros to accomplish: $1)$ transfer the data; $2)$ for

Insert a comment and include your name$($s$)$ at the beginning of the module.

b$.$ Transfer the information from each regional sales record worksheet to the "Consolidate$$ worksheet. Sales numbers should be inserted into corresponding positions

c$.$ Bd$.$ In A$16,$ insert the label "Sum" and calculate the sum of sales for each region.oldface the title row $($B$3$:E$3)$