Confused, but maybe something like this is what you're looking for:

ActiveSheet.Next.Select

This will select the next sheet to the right of whichever one is
active when this executes. If the farthest right sheet (last sheet)
is active when this runs, it will return an error (#91) that you'll
need to handle.

Regards,
Steve Hieb