Create dynamic link to multiple worksheets/workbooks

[Gerry at Maxx]

Is there a way to link one cell to multiple worksheets? I would like to have
the option to select data from one worksheet or another worksheet.

 

[Frank Kabel]

Hi
have a look at the INDIRECT function