right now i have a few variables explicitly set in a summary workbook:

filename$(1) = "[workbook1.xls]"
.........
to.
........
filename$(20) = "[workbook20.xls]"


what i want to do is list the filenames on a separate sheet in the summary
workbook so i can mange them more easily

how would i set the above variables to reference a cell's value (b1:b20) on
that sheet?

thanks
--


Gary