I have 3 separate Workbooks i have setup that store BUY/SELL prices etc
among other data.

I have found that sometimes 1 user updates their BUY/SELL prices in their
workbook, but really the other 2 Users workbooks need to be updated also to
reflect the same values.

So i was thinking of Creating a SEPARATE Workbook that ONLY has 1 sheet to
Display the BUY/SELL values.

If ANY changes are made to this workbook Sheet, then i want to via a Macro
UPDATE the Users BUY/SELL values accordingly.

How do i Identify the Users Workbook and then UPDATE the values, then CLOSE
them again by running 1 section of code?

I am not sure where to begin.

Corey....