VBA command switch between worksheets / tabs without names

I export data from Oracle and each time I export the export file name and tab is named something different. So I can't write a macro to select a tab to rename it when the tab name is different each time a new export is done from Oracle. What I want is to write a VBA code to rename the worksheet's or tab's name to "OR" without quotation marks.

or another option would be;

Since I wasn't able to rename the tab using VBA because it would require knowing the name of the file, so instead I modified my macro to create a new worksheet called sheet1 and attempted to copy the data from the other tab using the previous tab command/function (unsure what the correct terminology to use here). Unfortunately, it failed to go to the previous tab because I can't click the tab using create macro because it would write a vba script with the exact name of the oracle created tab that changes each time. So is there a VBA script that switches between tabs without having to click it and without knowing the name of the worksheet or tab?

Answer both if you don't mind.

I open it manually through the prompt from exporting it. So the file name is not an issue just the tab / worksheet name.

Just one sheet imports to excel.

I will test it out and get back to you tomorrow. Thanks for responding so quickly.

Thisworkbook.worksheets(1).Name = "OR" didn't work for me but Activeworksheet.name = "OR" did. Thank you for your help.

It did not work or even run.