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?
You can get data from desired sheet without selecting them one-by-one. Please mention sheet names in one column and try below formula:
Hope it will help
A sample file is also attached for your reference.
Though I need the whole sheet rather than a cell in it, your answer inspired me. Thank you .
@mengsheng You are welcome, you may share actual data so that more relevant and specific solution can be suggested.