link the data of different sheets to change table data

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

Dropdown list date.PNG

using formula
Formula date.PNG

this is my problem
drop down customer.PNG

INDIRECT may helps.
Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

As bebo021999 said, INDIRECT() may come handy in this problem.

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

This will only work if data range on every sheet is same.

Please hit the "Add Reputation" button if you liked the answer.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.