VBA - Open Multiple Workbooks, copy values into one workbook and put in array format

Hi,

I'm new to this forum! Thank you for having this great resource!

Step 1. I need to open 279 excel workbooks (each having 1 sheet).
Step 2. I need to get the value on the left and the associated value on the right.
Step 3. Then I need to put all of these values into a new workbook/worksheet and display them in an array.

Problem: The values in the spreadsheets are disorganized with merged cells and not always starting in A1.

Example:
First populated cell in this particular workbook/worksheet: B1 is merged with cells C1,D1,E1

values.JPG

Thank you!!

Yes, I added all of the workbooks into the same folder on my C Drive.