How to extract specified work sheets

[mengsheng]

I have a excel contains 186 sheets, naming like 1, 2, 3, 4, ..... 186.  If I want to get sheets numbered  33, 47, 67, 89, 101, 111...（like 30 sheets）. Can I get the result without select them one by one?

[#2]

Hi @mengsheng 

You can get data from desired sheet without selecting them one-by-one. Please mention sheet names in one column and try below formula:

=INDIRECT(B6&"!A1")

Hope it will help

A sample file is also attached for your reference.

Thanks

Tauqeer

[#3]

@tauqeeracma 

Though I need the whole sheet rather than a cell in it, your answer inspired me. Thank you .  :D

[#4]

@mengsheng You are welcome, you may share actual data so that more relevant and specific solution can be suggested.

Thanks