A macro is a series of instructions that you, as a user, can automatically direct Excel to execute upon the push of a button.  

It saves time and is very helpful if you take the same steps with various reports in Excel.  

These instructions can be saved to your personal macro workbooks in Excel to use whenever needed.

Step 1: Ensure the Developer Tab is visible by going to File>Options>Customize Ribbon.

Step 2: Select Developer Tab, then select Record Macro.

Step 3: On the following screen, enter the Macro name at a minimum, then click OK.

Step 4: Insert Instructions

For this example, the following instructions will take place

1. Specific Text entered into G2
2. CONCAT Formula inserted
3. Hide excess rows
4. Name column will be sorted

Step 5: Return to the Developer Tab and select Stop Recording.

The macro is now saved.

To run your saved macro, select the Developer Tab>Macros as shown below.

Search for the macro and click Run.

This will repeat all the steps you recorded as instructions for any sheet.