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...