I have an excel workbook with 500 worksheets. An example worksheet is shown in the image below. I am only interested in the data in column
E of every one of these 500 sheets.
Is there an easy way for me to take column
E from every worksheet and put them in a new worksheet?
I don't want to do any calculations on them, just display all 500 column Es in a new worksheet.
I've been googling and can't find a solution.
Format of the worksheets: