Connect data from hundreds of closed workbooks to one workbook

[rgmatos3]

Dear Scientists,

I have a simple problem but I really can't find an elegant solution (not ctrl + c and ctrl v).

Workbook "2014 Sales.xlsx" must have 12 worksheets, one per month, which one must have 31 columns that gets data from workbooks 2014 01 01.xlsx; 2014 01 02.xlsx 2014; 01 03.xlsx;... and so on, as externals links. And I must say that, I can NOT work with 31 different worksheets all open at the same time!

I know that, there is no way to make INDIRECT (....) read from closed workbooks. Period.

Is there a simple way to make that work? Maybe by using =procv(....).... Please don't send me complex solutions (VBA). I don't know how to use that!

I did a small example, but it gives you an idea.

Thanks and keep it easy, literally.

Workbook 2014 Sales

Sales	Days
Shops	1	2	3
a
b
c
d
e

<tbody>
</tbody>

Workbook 2014 01 01
Worksheet NY

Shops	Sales
a	101
b	102
c	103
d	104

<tbody>
</tbody>

Worksheet CA

Shops	Sales
e	105

<tbody>
</tbody>

Workbook 2014 01 02
Worksheet NY

Shops	Sales
a	201
b	202
c	203
d	204

<tbody>
</tbody>

Worksheet CA

Shops	Sales
e	205

<tbody>
</tbody>

Workbook 2014 01 03
Worksheet NY

Shops	Sales
a	301
b	302
c	303
d	304

<tbody>
</tbody>

Worksheet CA

Shops	Sales
e	305

<tbody>
</tbody>

 

[Jadre]

if u want to connect to other excel documents take get certain information from them go to data tab click existing connections and select a blank one and click what info you want to connect hope it helps