Link on chart sheet to select which data sheet to use

Good morning all ... your assistance is greatly appreciated.

I have a chart on Sheet1. Next to the chart I list in four separate cells: Qtr1, Qtr2, Qtr3, Qtr4.
Each of the four represent a separate Sheet with data for that period, including the title indicating the chosen Qtr. (All I know how to do is to link the Title Box to a worksheet cell.)

I am attempting to permit the user to click on the Qtr of choice from the list and have that data selected to make up the chart.
For example (just to be perfectly clear): When user is viewing Sheet1 one, the only unprotected cells are those with the Qtr choices. If user selects Qtr2 the data from the worksheet Qtr2 will be used to complete the chart. A cell in Qtr2 will contain the title text "Qtr2 Data" which will need be used for the chart title.

If this is possible, please share your thoughts (instructions) with me. Thanks, have a good day!

Thanks adyteo, this is exactly what I'm trying to do. But, I haven't quite figured out how to do what you did.
I made the dropdown (K4) and used the CHOOSE function (M4) as you did. I can select the number and get the correct link in M4.

I cannot figure HOW you made the chart use the selected data. I see the chart titled "Values" and when I look at the chart filters I see the series "Values". When I select the chart I see [ =SERIES("Values",,Main!QuarterSel,1) ] in the dialogue box. Your sheetTabs are named Quarter_1, Quart_2, etc but in the Series function it uses "QuarterSel".
Also, I would like the Title of the chart [which you show as Values] to be the name of the source of the data. (ex: Quarter_1 when that is the source).

Please see if you can walk me through it.
Thanks!

Hi,

What an excellent template by adyteo!

I have just modified it to reflect the 'Chart Title' as per the 'Quarter' selected (file attached).

Thank you both for your help. We are close but not there yet. Obviously I'm not catching on easily.
Please look at the attached spreadsheet and you'll see more clearly what I'm trying to do and more importantly, what I'm doing wrong.
If you'll look at the main sheet labeled CHART you'll see where I entered notes.
Thanks!

QuarterlyFalls.xlsx

Thank you for your generous help adyteo (and you too cbatrody). This makes my project much more efficient and useful.