Worksheet Download Random Name - Wildcard?

[Small Paul]

Hi All

Sorry, I have to ask for a bit of help here.

I have a daily report downloaded which gives a worksheet name of 'report123456' but the numbers are randomly generated. In order for my subsequent macro to work, I think I need to either:
a) change the worksheet name to 'Data'
b) have a way whereby the sheet is active, no matter what the random numbers are

If somebody could help it would be appreciated.

Many thanks
Small Paul.

 

[BarryL]

you could reference the index of the sheet i.e. if it is the first sheet it would be "Sheets(1)" in VBA.