I have just taken over a new job at the hospital system I work for to annually inspect the Medical Gas equipment in each patient room of our many hospitals. In recent years different people have been doing them each year, who really didn't care, and the patient rooms and different floors are all out of order on the workbooks, yet the worksheet tab names are counted Patient Outlet Page (1), Patient Outlet Page (2), Patient Outlet Page (3), etc..I had to move the sheets around to put them in their actual order based on floor and patient room number, but now the worksheet names are out of order. Is there a way to rename multiple worksheets(all 87 of them) within an entire workbook?