I'm using the code below to select a number of worksheets. Is it possible to list the sheetnames on a sheet called "Report" rather than hard code them in? The names will change as will the number of sheets I need to select.
I've spent hours looking on the internet but cannot find an answer to this question.
Sheets(Array("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday", "Week 01", "Week 02", "Week 03", "Week 04", "Week 05")).Select