I'm pretty sure I've done this before, but can't recall the syntax...

I have a variable strDataSheetName that is a string and refers to the name
of a worksheet. I have it as a string variable, because the name of the
sheet I want to refer to has to do with the name of the sheet I am on.

How do I select this sheet using the variable name? See code below (this
syntax does not work)...

ActiveChart.SetSourceData Source:=Sheets("" &
strDataSheetName).Columns("A:F"), PlotBy:=xlColumns

Thanks!