Someone told me how to do this put I have misplaced my notes:

Workbook A is a consolidation workbook that links to named ranges in
"source" Workbooks B, C, D, E....etc. There is a way to display all the named
ranges in the source workbooks and to select them by pointing, so as to
reduce the chance of formula typos. I just don't remember how. Help,
please!!!! and Thanks!