I need to pull values from about 80 excel files that are all in the same folder and named the exact same thing except for a datefield. Luckily, the value I need in each workbook is also in the exact same Cell.
So I am hoping that I can quickly pull all the data I need using this Formula:
except the date 05092018 is different for each file.
I have the date parsed out this way in the A column (A2 = 02072018, A3 = 02082018, A4 = 02092018, etc).
What would the formula be so that I can use the A Column cells as a variable in the above formula?