VBA needed to extract specific data from data dump list

I've come up with a very crude solution to my problem that involves multiple vlookups, countif and left statements to get the data I need from this list, but the problem is these reports can run 35,000+ rows long due to the data in column F. So my formula bogs down the file and crashes excel when the lists get too long or I try to do other analysis. I've attached a sample list that gets exported from our management software.

All I want from this list is to get the person's name who created the log (cell A2, additional rows below) and the type of log they created (column E) extracted to another sheet. So the new sheet would have column A = Created By, column B = Contact Method.

Please help!