Try this before you think of macros.

1/, Highlight the columns you need to copy

2/. Click on the Tab "Data" in the ribbon.

3/. Click on Filter.

4/. Click on the arrowhead in the right side of column F

5/. In the pop-up panel go to Text Filters > Begins With....

6/. In the resulting Dialogue box you will see
Show Rows Where:
begins with, in the box to the right type the single letter a

7/. Press Okay

8/. Select all the resultant rows, or the area you need
Copy and Paste to new sheet

9/. Remove the filter.


If you really need a macro for this, try recording a macro while following the above steps.