Summary Sheet Different Tabs

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?

Assume you have week5 in cell A1 of your summary sheet, then you can use these formulae in different cells:

=INDIRECT("'"&$A$1&"'!A1")
=INDIRECT("'"&$A$1&"'!A2")
=INDIRECT("'"&$A$1&"'!D3")

Hope this helps.

Pete

Ensure that the entry in A1 is spelled EXACTLY the same as the sheet tab - you may have a space at the end.

Hope this helps.

Pete

Figured it

I had to format A1 as a text. It now works perfectly.

Thank you very much.