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...