Change the targets of many cells at once

Hello all,

I was wondering if it's possible to change the targets of many cells on a tab at once based on a dropdown list the user can choose from.

Basically I've got a sheet where I am trying to show the comparisions between multiple sites with the same metrics one day at a time. This chart will draw it's information from a series of tabs which are updated via the export feature of another program. The actual cells in the formula need not change but I want it to switch the tab it's looking at.

For instance, if I want to look at day 1 information all the cells on the main page would point at the D1 tab, but if they switch it to D2 it would change to the D2 tab. There are some 42 odd tabs they would be able to look at.

I'm really trying to avoid just making 42 copies of the same table on a page for people to sift through.

Hi

See if the attached file gives you some ideas.


rylo