Hello, I have a fairly large workbook which acts as a type of manual with each sheet representing a page, and one of the first sheets acting as a kind of table of contents. The trouble I'm running into is keeping specific data on the pages the same as the corresponding data on the table of contents sheet.

So what I'd like to do to solve this problem is something like this:

1. Somehow name cells that need to display the same data so that the code can automatically 'group' them.
2. Have the code 'link' the cell groups so that a change to one would occur to all the rest, resulting in exactly the same data appearing in all the cells in the group.

Any ideas how I might go about this? Thanks in advance.