Jacob Jan Tuinstra's script was great! And a frustration- and time-saver! (Talk about frustration when you are dragging a tab and you're almost to the spot, and then you drop it (or lose it) in a place that isn't quite right and it jumps back to where you started!)
I've added some additional script tabs to the project to work with my document which has around 85+ sheets in it. I have revised the line:
ss.moveActiveSheet(0)
to:
ss.moveActiveSheet(55)
to move the active sheet to the middle of my document (which is at the end of a group of specific sheets),
or:
ss.moveActiveSheet(85)
to move the active sheet to the end (versus the beginning) of the document.
I found if you set the end sheet number too high, the script will fail when you run the debug, so if you don't want to count how many sheets you have, just play with the number.
Thanks, Jacob!
Ctrl
+/
will show you all of the available keyboard shortcuts. – ale Nov 1 '14 at 18:06