Change sheet index numbers in VBA?

Two-part question:

1 Does Excel process worksheets (tabs) in the left-to-right order in which the tabs appear visually? Or in the order of the worksheets' index numbers as they appear in the VBE Project Explorer window?

2 Is there a way to renumber or reassign index numbers to specific worksheets?

Thanks for your advice.