How to take information from Column A with multiple data to a new sheet as rows.

Good Morning!

I am hoping to gather insight into how to take information from one column, and implmenting a macro to display it in a different worksheet as columns. I received this data from a pdf document and downloaded it to excel. It's basically 250+ email messages in this format underneath one column. All have the same titles (Event / Incident), etc. I am hoping to build a macro to search for each title (e.g., Event / Incident) and then display this information into a 'Event / Incident Column'. Same would go for Commands Impacted, etc. Any insight would be awesome, thank you!

Below is the data in Column A (actual data is different from email to email, but headers 1 through 12 are the same).

1. Event / Incident:
2. Commands Impacted:
3. Operational Impact:
4. Root Cause:
5. WO Initial Notification:
6. Incident Start Date / Time:
7. End Date / Time:
8. Reason for outage (RFO):
9. Action Taken:
10. Resolution Summary:
11. Applicable Trouble Ticket(s):
12. Notifications:

Hi!

Attached is an example of the layout of one email. The same layout is utilized for 200+ emails that I hope to separate the information from the titles (e.g., Incident) into a separate worksheet as columns (see Desired Format tab).

Any help would be fantastic!

Morning! Just following up, anyone have any insight?