Hey everyone,

So I'm currently building a sales tracker that tracks 6 different restaurants on separate sheets in the workbook. Up till now everything has been super smooth, until I got to the breakdown (snapshot of all 6 broken down as a quick reference ie sales per week, discounts per week etc. etc. etc.) sheet. What I'm trying to achieve is having a drop down list with week1 to week 52 (Just the text) that when you change from week to week, the changes the data in each section for each restaurant changes to what ever week is selected for the whole sheet. Each individual sheet has the correct data for each week but I cant seem to find a corresponding formula that encompasses this. I've tried Vlookup, match, index, and every combo of them as well as if and ifs. nothing seems to be able to do this. Does anyone know another way???

Cheers,
Kyle