Use a formula like this in the 10 panels.

=Overview!A8


"Dallas" wrote:

Hi,

Let's say I have 10 panels, which I have called 1, 2, 3, ... 10. The
structure of the content in the 10 panels is identical, but the data
is not.

Let's say that I have created and panel that I call 'overview'. In
this 'overview' panel, I have a cell, where I can type the name of a
panel (say the number 8). When I change this value, the formulas in
the 'overview' panel change in the sense that they now link to the
panel I have typed (say 8).

Is this possible, and if so, how?