What function to link the data of different sheets to change table data

[kayafueya]

Hello folks. Need a help of this one. I have 19 sheets that has data each of days in a month in columns and hours in rows. I want to have a summary sheet where I can show chart automatically depending on the drop down list I select. I created drop down list for the sheets and the days in a month. (see Picture 1). I figured how to link days from the dropdown list but ONLY on SPECIFIC SHEET. My PROBLEM is how to link the different SHEETS in a cell so I can change the data of the table depending on what sheet I select on the dropdown list. See pictures. Thank you for the help.

=INDEX(ANECO!$B$7:$AF$30,MATCH(ANECO!A7,ANECO!$A$7:$A$30,0),MATCH(SUMMARY!$K$2,ANECO!$B$4:$AF$4,0))

How to make ANECO! change automatically based on the sheet?

I did this

Attachment 663632

using formula
Attachment 663633

this is my problem
Attachment 663634

[protonLeah]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread:https://www.excelforum.com/excel-formulas-and-functions/1306806-what-function-to-link-the-data-of-different-sheets-to-change-table-data.html