I need a VBA script that will allow me to reference a cell(s) in ALL worksheets automatically
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, A23 B5, B6, B7, B8, B9, B12, B13, B14, B15, B16, B17, B18, B19 F6, F7, F8, F9, F10 J6, J7, J8, J9, J10