Is there a way to have the name of a workbook in a formula from a column in
another column? For example, the workbook's name is in A1 like test.xls, the
formula will be in column b referencing test.xls as follows:

='[" & A1 & "]tabname'!$B$8

Thanks!