I have a spreadsheet that contains pricing that is calculated by referencing
cells in various other workbooks saved under customer names (not at the same
time).

I need to create a macro that will allow me to easily link my pricing
workbook to my customer workbooks. Any macro that I have tried to create to
accomplish that limits itself to the workbook I pointed it to while creating
it.

Is there a way to write the code that can be flexible to reference any
workbook and not specifically the workbook it originally referenced?

Hope that made sense. I'm stuck. I've tried all kinds of tricks. Thank you.
--
David P.