Sorting Alphanumeric Values in multiple columns

[data808]

Hi, I'm having issues sorting values that will have dashes, numbers, and letters in multiple merged columns. Ultimately what I would like is a button that I can create some VBA behind it or something that will sort this data when I click on it. Another option is if it can just sort the values on the fly as I type them into the cells. Examples of the values will look like this:

1ABC-10-455781
1ABI-11-322411
1ABP-10-769112

Below is an example of how it looks on the spreadsheet. The merged cells for that first value (1ABC-19-509451) is from columns B-H starting on row 10. The cell next to "26" in the next column over is merged from J-P. The last column on the far right starting from number "51", the cell next to it is merged from R-X. Each of those numbers from 1-75 is each a cell. It has nothing to do with the values other than keeping a record number for it. Of course those numbers do not need to be sorted and those cells will be locked from the user to edit. I will entering values in all 3 columns in sequence but most times will only use 1 or 2 columns because I will run out of values to enter for the day. I would like the values to be sorted in some kind of order if possible. Thank you so much for taking the time to help with this dilemma.

1	1ABC-19-509451	26		51
2	1ABI-19-509602	27		52
3	1ABC-19-509901	28		53
4	1ABI-19-510103	29		54
5	1ABC-19-510203	30		55
6	1ABI-19-510412	31		56
7		32		57
8		33		58
9		34		59
10		35		60
11		36		61
12		37		62
13		38		63
14		39		64
15		40		65
16		41		66
17		42		67
18		43		68
19		44		69
20		45		70
21		46		71
22		47		72
23		48		73
24		49		74
25		50		75

<tbody>
</tbody>

 

[data808]

Not sure why the columns are so uneven shown in my post above, but just FYI, on the spreadsheet they are equally spaced out. Thanks.