I have a huge excel master workbook with 30 worksheets to report data from 50
other workbooks... to add a single workbook to the master file is a huge
task...

I want to create a list of files to call in and automatically add to the
growing list.

Example:

where Filename "test.xls" is in cell A2

='[A2]sheet1!'F13

having said that I want A2 to step up as I drag and expand the list...