Sort a range with numbers, numbers suffix with letter and numbers mixed with text

Hi,

I have a range with a column containing numbers, numbers suffix with letter and numbers mixed with text. I need a VBA macro that sorts the numbers at the top and numbers with suffixes and numbers with text at the bottom. The column by which they wish to sort is dynamic and the range starts at row 4 and the last used column and row are determined dynamically. Usually the number of columns are around 60, that could change though.

And the user can sort by column containing numbers, numbers suffix with letter, numbers + text, column containing dates, column containing text, column containing alphanumeric data. Need two separate macros to sort ascending and sort descending.

I referred to Jindon's code from these threads -> "sorting mixed text and numbers" thread, and "optimize vba code without copy and paste" thread. I'm new to this forum and it won't let me add links.

But I need help with modifying to suit my needs.

For example, I would like the sort to return by a column

11112
11112C
12345
12345A
12345B
13456
13456B
13456D

currently it returns
11112
12345
13456
11112C
12345A
12345B
13456B
13456D

Thanks in advance for your help!