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