Hi,

I have a large exel file with a tab for each week, I would like to create a sumary/print sheet for a specific week at any time. I want to just add the tab name to a cell in the summary page and i gets the data from that tab.

For example:

I need to pull the data from cell a1, a2, d3 from tab week5

But then I may need to pull the same data from week7

Is there a way I can have a vlookup just by entering the relevant tab name into a cell?
So if I enter week5 into a cell I could get the formula of ='week5'!a1 in another cell?