Using INDIRECT function within Chart 'Select Data' formula?

Before I spend the rest of eternity figuring out how to do it, I thought I'd ask to see if it was possible?

Looking to auto-populate a worksheet full of charts (or dashboard, if you like) with data from many other worksheets, without having to edit each chart. If I could just enter the name of the worksheet in one column, the chart could use the data relating to that sheet.

C'est possible?

Many thanks,
Dave.

Sut mae,

You can't use Indirect() in a chart source formula. But you CAN create a named range that uses Indirect() and then use than range name as the chart source.

you could maybe use something like this