Excel Functions

Consolidation

=INDIRECT("'[SECOND_FILE.XLS]"&MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,256)&"'!$"&SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")&ROW())