Cross workbook referencing based on cell input

Hey guys,
I have a 'summary' sheet that references other workbooks and polls data from
specific cells on those sheets. Currently I have to 'hard-code' the
references to those other workbooks on my summary sheet - is there a way I
can use input from a cell to determine which other workbooks are referenced,
instead of having to hard-code this into the sheet? That way a user can
determine which other sheets are referenced.

I'm sure this involves macros, cunning visual basic jiggery pokery, and/or
voodoo magic. All replies, even the voodoo ones, are gratefully appreciated!

NMG

Hi Neal

The indirect function will not work with closed workbooks.
But you can run a macro to do this

Maybe this will give you some ideas
http://www.rondebruin.nl/summary2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Neil Mitchell-Goodson" <[email protected]> wrote in message
news:[email protected]...
> Hey guys,
> I have a 'summary' sheet that references other workbooks and polls data from
> specific cells on those sheets. Currently I have to 'hard-code' the
> references to those other workbooks on my summary sheet - is there a way I
> can use input from a cell to determine which other workbooks are referenced,
> instead of having to hard-code this into the sheet? That way a user can
> determine which other sheets are referenced.
>
> I'm sure this involves macros, cunning visual basic jiggery pokery, and/or
> voodoo magic. All replies, even the voodoo ones, are gratefully appreciated!
>
> NMG
>
>