Mirroring Cells?

Hi,

What I would like to do is to create a copy of a table I have formulated and have it so that if I change a figure in one table, it will be mirrored on the other, and vise versar. I know that I can do A1 = B1, but that would mean I can only change B1 and have it replicated in A1. I want the option to change either A1 or B1 and have it replicated in the other.

Ultimately I would like to be able to make multiple copies of the same table and have them all linked.

I'm not sure if I've made myself clear, still very new to excel.

I'd appreciate any help you can offer!

Jack