Changing ranges in chart based on drop down

Hi all,
I am not very knowledgeable when it comes to the dynamic part of excel but what I am wanting to do is basically have the chart on the tab labeled "visual coverage" based on the pull down menu listed just to the left of the chart which coincides with the day of the week.
The data that I am pulling this info from is on the same page but to the right starting in column AA.
The Sunday info is correct and I would like it to stay in that format but change with the day of the week when the menu is pulled down.
Any help would be greatly appreciated! I'll wait up to see if we can knock this thing out tonight!
Workbook attached.New Store Schedule.xlsx

Hi,

Have a look at column AA. Underneath your tables I've added a new one. This table uses INDEX and MATCH to pull data from your original tables depending on which day is selected.

Hope that's of help.

BSB.

You are THE MAN! Genius solution. Thank you VERY much for your help. It truly is appreciated!

Glad I could help.

Feel free to mark the tread as solved if you're happy with the solution.

BSB