Select all worksheets
 

Hi, I have a code that will filter a list and create a spreadsheet for each
value in a particular column. Eg. Student marks for subjects, user inputs
data into sheet, and filters it by course. There are 3 courses, maths,
english and science. If a student only does maths and science, it will only
filter these two and create a maths and science worksheet with these values.

How do I
a) Select all the worksheets that exist (obviously this changes depending on
how many sheets get generated by the filter) and
b) Arrange the worksheet tab in a particular order (eg. maths, science,
english - if a student only does maths and english, it will arrange it in
maths then english as science worksheet does not exist).

Can someone help me with this please?