Database Retrieval, Edit, and Upload

[atdemeo]

Here's my scenario.

I have an external program that can export a database of information. This can be done via XML, CSV, SQL, ODBC, DSN, etc.
I have an excel workbook that manages this information. Various formulas, calulations, formatting, etc. It is all based on the same source information from the Database.

The first tab in my workbook is simply called source, and following tabs and tables will reference the source tab.
Is there a way to Link values from cell to cell? The actual link function does not seem to help.

For example:

Source!$a$1, Sheet2!$a$1, Sheet2!$a$1

Is there a way to link these three cells so that when I change the value from any tab and have it update in the other tabs? Right now I have Sheets 2 and 3 referencing the Source sheet with index match formulas, but I need to change the value, I have to go find it in the source sheet, which is inefficient.

Furthermore, after I make these changes, which are reflected in the Source tab by all of the links, I need to export the source sheet back into the database in order to update the external program, via one of the database options I mentioned above.

Is this possible with Excel, or is the communication strictly a one way import? The external program supports ODBC or SQL, and I have read that it is the most efficient way to interact with the data, but I have no idea how well excel interacts with it, if it is a two way system, etc.

I might be talking complete nonsense here, so I appreciate your patience.

Any advice you can lend would be great.

Thanks,

[dflak]

The following is based on the verbal description and it makes some assumptions. The main assumption is that a cell is linked to its counterpart on the other two sheets. So A1 is linked to A1 and not some other cell. If this is not the case, then you'd need some sort of map showing which cells on which pages are linked.

Make a change event on each page. Then take the target and copy it to the same address on the other two pages. You'll probably have to disable events so you don't wind up in an infinite loop.