Giant Index copy and paste problem. I'd appreciate any help you could provide.

[ned lud]

I have ~2000 worksheets.

Each one is identified by a unique set of letters and numbers. For example one worksheet name is "ABS9". The "ABS9" is the name of the worksheet. In the ABS9 worksheet, there are two cells, one would have "ABS" and the other would have "9". And in each sheet there is data from cell B3:I150.

What I want to do is have an INDEX sheet where the user can type in in "ABS" in one cell and "9" in another cell and then the data (B3:I150) from the ABS9 worksheet will be copied and pasted into the INDEX sheet.

Is this possible? I can't figure it out.

Thank you.

 

[MountainFog]

Where A1 is ABS and B1 is 9

=INDIRECT("'"&A1&B1&"'!B3:I150")

Let me know if that doesn't work. I don't know if Excel 2019 supports this

 

[ned lud]

Where A1 is ABS and B1 is 9

=INDIRECT("'"&A1&B1&"'!B3:I150")

Let me know if that doesn't work. I don't know if Excel 2019 supports this

Thank you very much. Had to play with it a little bit but this works perfectly. No idea it would be that easy.