Using Indirect Function

See more:

MS-Excel

Hello

I have a workbooks

Warehouse PMS Week 36

Warehouse PMS Week 37

Warehouse PMS Week 38

Then i have a sheet with table like that

A       B          C        D                    E
Week Planned	Actual	Reason			Action Comment		
35	 #REF!	 #REF!							
36	 #REF!	 #REF!							
37	 #REF!	 #REF!							
38	 #REF!	 #REF!							
39	 #REF!	 #REF!							

Each the REF in Column B contening

='[Warehouse PMS Week 37.xls]Total PMS'!$E$113

And in Colum C

='[Warehouse PMS Week 38.xls]Total PMS'!$F$113

now i want to do something like that i want to replace 35 in

Warehouse PMS Week 35.xls

With INDIRECT("A2") and so go on but i don't have luck with that and my formula dont work :(

The whole point is i have like 52 weeks and i want link them to this table and get the values from Week Periods im curently in thats mean in moment when i change the A2:A6 with other nr like 42 or 52 the sheet will link it strate to this workbooks

Any help with That ? or any better solutions