How can I get the data by entering sheet name?

[Asghar Hussain]

Hi guys,
I have a Excel work book consisting of 200+ sheets (tabs), every sheet has some data in it, all I want is I enter the sheet name and I get the data present in it.
Like, = vlookup(sheet name), and I get the data present in the sheet.
How can I do this guys

 

[My Aswer Is This]

Hi guys,
I have a Excel work book consisting of 200+ sheets (tabs), every sheet has some data in it, all I want is I enter the sheet name and I get the data present in it.
Like, = vlookup(sheet name), and I get the data present in the sheet.
How can I do this guys

You want to enter sheet name where and get what data from that sheet?

 

[Asghar Hussain]

You want to enter sheet name where and get what data from that sheet?

Thanks for replying,This is my workbook (image 1), with 200+ sheets(tabs)

 

[Asghar Hussain]

Thanks for replying,This is my workbook (image 1), with 200+ sheets(tabs)

Every Sheet (tab) have data (image 2),

All I want is, I enter the sheet name in a cell on the index page and I get the data present in the sheet,
Like in image 3

 

[My Aswer Is This]

On the sheet named: "INDEX"
Enter a sheet name in Range("A1") and copy all the data in that sheet to the sheet named "INDEX"

Is that what you want?

 

[Asghar Hussain]

Yes, the cell may be A1 or any cell in between

 

[My Aswer Is This]

I asked:
On the sheet named: "INDEX"
Enter a sheet name in Range("A1") and copy all the data in that sheet to the sheet named "INDEX"

Is that what you want?
You said:
Yes, the cell may be A1 or any cell in between
What does that mean?
or any cell in between

There are about 12 billion cells in a worksheet.

 

[Asghar Hussain]

Ok, Sorry for being un elaborative,
I'll start from beginning
I have excel sheet with 200+ tabs (image 1)
Every tab have same type of data (same heading but data different) (image 2)
Now, I want to view all the data from index tab instead of going to every tab manually
For Example, I have Florida High School on tab no. 11, (image 3)
Data in tab 11 looks like this (image 4)
My data in every tab is in row "A to K" (as you can see in image 2,4)
If I enter tab no. " " on index tab cell no "J2" I should get the data present in that tab in cell no. "L1"
Final result should be like image 5
On the index sheet cell J2 I have entered tab name & I get the data in the tab in cell L1
Thanks.....

 

[shaowu459]

It could be done by INDIRECT.

INDIRECT function - Microsoft Support

How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.

support.microsoft.com

 

[Asghar Hussain]

I dont see how indirect will be helpful....