Arranging Numbers in the following order

[wings1080]

hi geniuses

I have data I am looking through that is ordered like this, let’s say one data set has items numbered 1 through 88 then 1000 to 1007 so 95 total items, well, I am having to look through all of them and in a separate spreadsheet to the side I am entering in information about each item, THAT spreadsheet is in numerical order, i.e. 1,2,3,4,5,6,7,8,9,10,11,12,13 .... 10007, HOWEVER the order the items I am looking through is in an order like this below ...

what I want is to order my spreadsheet that I enter information into in this same order as below, is there a way I can apply some kind of formula or something to my item # in a separate column and sort the sheet by that column to achieve this?

1
10
100
1000
1001
1002
1003
1004
1005
1006
1007
2
20
21
22
23
24
25
26
27
28
29
3
30
31
32
etc...

[Special-K]

Your data is text thats why the 1s, 10s, 100s, 1000s are grouped together then the 2s etc

In a Helper column say column B
=A1+0
Then sort on column B

[wings1080]

thanks but no, I can't sort the stuff where the label is actually text I need to arrange the other spreadsheet to match the order, that spreadsheet the items are in numerical format yet I need to sort them in the same order listed above