In my workbook I have multiple sheets.
I have a summary sheet, called: Graphs, consisting of (only) graphs,
build from the data from the various sheets. These graphs do not change.
I would like to determine (via the Graph-sheet), from which worksheet
the data should come from.

For a (particular) graph, the [chart data range] is, e.g.:
='Sheet100'!$F$6:$F$10
The value: "Sheet100" is what I would like to choose/vary;
- preferably by selecting a cell with the name of the sheet I want the
graph(s) made from (e.g. A1=Sheet100; A2=Sheet200 aso.
By seecting Cell A2 (on sheet: Graphs) the graphs will be build using the
data on Sheet200 . . . , or:
- by typing the name of a worksheet in a (fixed) cell
(e.g. typing: Sheet200 in Cell A1)

Note: all the worksheets have the same columns (but may vary in number of
rows, although this could be also made the same).
Hope you understand my question !

Regards,

Paul