Good Morning!

I have many Input workbooks, all identical except for the data values. On my Result workbook I want to extract the value at cell A1 from each of the other workbooks. The resulting values will appear starting in Column B1 through Bx.

I know this can be done in VBA and have done so in the past. My question is this: can the same result be accomplished with array formulas in the Result workbook?

Thanks in advance for your thoughts.

tom