Return name of current worksheet

[Newbie_nick]

I have data in numerous CSV files, and when I open them in Excel, the
worksheet name is the same name of the CSV file. Since I have numerous files
all with different names, I would like to write a macro to select the current
sheet and rename it as something generic like "Raw data". I'm sure that this
is an easy request, but I'm struggling with it!

thanks!
Nick

 

[Bob Phillips]

Activesheet.Name = "Raw data"