We created an Excel spreadsheet form for multiple hospitals to enter their data. As the end, we now have 17 separate Excel files that each contain 31 worksheets. I need to get data from reach of the 17 files. need to get the numbers from three cells (Numerator, denominator, & rate) from 26 of the 31 worksheets in each of the 17 files. For most of the 26 worksheets the three cells are in the same spot (24 of them). For one worksheet (in the 17 files), I will need to copy four sets of 3 cells and from one other worksheet, I only need to copy 1 cell. I would be satisfied if I could automate linking the cells in the same location (for 24 of the worksheets) and then doing the other two the long way,
I know that I could do this the long way by going into the Master file and then put = in a cell and then go into each file an then each worksheet and click into the cell I want, but that would take forever. I could also in the master file use code in the cell and do something like put = and then put the filename, worksheet name, and cell in each cell in the mater file, but this also would take too long.
I know this can be automated and have seen some videos and text of some things that are similar to what I need, but nothing that matches. Therefore, I am asking here with the hope someone can tell me how to do this or point me to the right resource.
Thank you.
I know that I could do this the long way by going into the Master file and then put = in a cell and then go into each file an then each worksheet and click into the cell I want, but that would take forever. I could also in the master file use code in the cell and do something like put = and then put the filename, worksheet name, and cell in each cell in the mater file, but this also would take too long.
I know this can be automated and have seen some videos and text of some things that are similar to what I need, but nothing that matches. Therefore, I am asking here with the hope someone can tell me how to do this or point me to the right resource.
Thank you.