I have a workbook that has almost 1500 worksheets. Each worksheet is not set up as a table. Some cells may contain data or text. I am needing to pull specific cells in all worksheets into one worksheet. Doing this will allow me to create a table with the data that I want. If the workbook was smaller I could simply use a formula to return a cell, but I can't do this for nearly 1500 sheets.
Can someone write me a script that will allow me to pull the data/text in a specific cell in all (almost 1500 worksheet) worksheets. I was hoping if someone did at least one, I could copy and paste or figure out how to duplicate that script to all the other cells I need.
In case you need this information. The cells that I am needing are as follows:
A12, A13, A14, A15, A16, A17, A18, A19, A20
B5, B6, B7, B8, B9, B12, B13, B14, B15, B16, B17, B18, B19, B20
F6, F7, F8, F9, F10
J6, J7, J8, J9, J10
Bookmarks