Basically I have a dashboard. Right now B1 is =Pvts!B2 which is the week on the pivot table. I am looking for a way to create a drop down so you can change the week on the dashboard and the pivot table with change to that week as well. Any help would be greatly appreciated! Thank you