Hello,
I have a workbook with 120 tabs. Each tab has a different different name, but each tab has values in cells w12, x12, y12, z12, aa12 that i would like to get.
Essentially I am trying to create a summary sheet that has the sheet names in column A and then the corresponding values. it would look like this
<tbody>
</tbody>
I was hoping there was a way to use VBA to first list out all of the sheet names in column A and then go to each sheet and pull the values in cells w12, x12, y12, z12, and aa12. Is this possible? Thanks!
I have a workbook with 120 tabs. Each tab has a different different name, but each tab has values in cells w12, x12, y12, z12, aa12 that i would like to get.
Essentially I am trying to create a summary sheet that has the sheet names in column A and then the corresponding values. it would look like this
SHEET NAME | 10TH% | 25TH% | Median | 75th% | 90th% |
cardiology | cell w12 | cell x12 | celly12 | cell z12 | cell aa12 |
dermatology | cell w12 | cell x12 | cell y12 | cell z12 | cell aa12 |
emergency medicine | cell w12 | cell x12 | cell y12 | cell z12 | cell aa12 |
<tbody>
</tbody>
I was hoping there was a way to use VBA to first list out all of the sheet names in column A and then go to each sheet and pull the values in cells w12, x12, y12, z12, and aa12. Is this possible? Thanks!