rearrange tabs based on order specified by list box

[mcdermott2]

Hello all,

--I have a macro that opens many excel spreadsheets and saves the first worksheet as a new tab in a "master" spreadsheet. The "master" spreadsheet then names each tab based on the question # found in each worksheet.

So, my "master" worksheet has tabs named something like:

q1 q2a q3 q5

What I need to do is create a list box which lists out all of the tab names, allows me to choose the order that the tabs will appear, and then rearrange the tabs to reflect that order


So, for the above, I need a list box which would display:
q1
q2a
q3
q5

and would allow me to specify that the order I want to be:
q5
q2a
q1
q3
(or whatever order I want)

and then rearrange the tabs so they appear as:
q5 q2a q1 q3


The number of tabs and the names of the tabs will vary.

Thanks for the help!

[djbomaha]

Hi McDermott2,

I have attached a file that has a macro that reorders the worksheet tabs based on user choices from a user form. Hit "<CTRL> a" to run the macro. You can view it by hitting "<ALT> <F11>". Hopefully this helps.

Thanks,

Daniel

[mcdermott2]

Thank you very much, djbomaha! Works like a charm.