I have a macro that simply copies the rows from all worksheets that are not
named "IB_Status" to the worksheet "IB_Status". All of the worksheets have
the same columns; one of the columns is a "Sort_Order" column. I want the
rows to retain the sort order entered from their original sheet (it doesn't
matter if there are duplicates). Somehow the values are changed when they
get to the "IB_Status" sheet. It looks like Excel is autonumbering them
sequentially for me. I have tried formatting these columns as text before I
copy them. I have tried Disabling AutoComplete under Tools | Options | Edit.
Nothing has worked.

I need help retaining the value from the original sheet--this is driving me
crazy!
Thank you,
Judy