You can loop through the sheets programmatically and reverse their order using code similar to the following:
Sub ReverseSheets() Dim i As Integer For i = 1 To Worksheets().count Worksheets(i).Move before:=Worksheets(1) Next i End Sub
This code will automatically reverse all sheets in a workbook. The exact number of sheets is irrelevant because it checks for the number of sheets each time.
As for searching for sheet names, it is possible but significantly more complicated than reversing the sheets. Here are a couple of sites to get you started:
http://automation-beyond.com/2010/01/27/how-to-find-excel-worksheet-by-name/
http://www.mrexcel.com/forum/excel-questions/58374-visual-basic-applications-find-sheet-name.html