First, I believe the activesheet.name is a value that changes each time a new tab is selected? If I'm wrong there, the rest of this is not going to make sense. Please correct me if mistaken.
If Sheet3 has lots of data collected, I'd like to sort the data depending on which of the other Sheets...