How to create a macro to sort 2 non-adjacent columns?

[helpneeded2]

I have a sheet that contains ID numbers that a user enters in Column "A". They then hit a "retrieve data button" which populates data in Columns B to D. Then in Column "E" they enter the name of the user who entered the ID number.

Since from time to time, ID numbers will be added or removed in Column "A", I want a quick way to remove any blank cells. Sorting the ID's numerically is not necessarily required but is a nice added feature. However, I want the data in column E to always remain linked to Column A. Columns B to D are just XLookups grabbing data from a data sheet based on the ID number in Column A.

I would ideally like to make a "sort data" button to run a macro that sorts Columns A and E. I cannot figure out how to do this, since sorts need to be by an uninterrupted range. I would greatly prefer not to move my data in Column E to Column B to make this work, so I was wondering if this can be done in VBA?

 

[helpneeded2]

After some more searching, I think I found an example on Stackoverflow that partially addresses this but the results are pasted as a range on another sheet, as opposed back to the columns it obtained the data from, and I can't figure out how to do that.

VBA - Sort a single column based upon values in another, non-adjacent column

Suppose I have the following range in an Excel (2016) worksheet: Sort Order: Col1: Col2: 3 A A 4 B B 2 C C 1 D ...

stackoverflow.com