Hello, I hope I can obtain an efficient method of accomplishing the following task

I have an Excel XP file in which there are several sheets. The names of the sheets and the quantity of sheets are relatively static. The main sheet is the PROGRAM sheet. All other sheets in the file are related to the data in the PROGRAM sheet based on rows

The Catch: The number of rows in the PROGRAM sheet grows and shrinks

The Problem: Keep all the sheets in the file synchronized with the PROGRAM sheet

For example, if row 247 on the PROGRAM sheet is deleted, then row 247 needs to be deleted from all the other sheets in the file. If a new row is inserted at row 89 on the PROGRAM sheet, then a new row needs to be inserted at row 89 on all the other sheets in the file.

The PROGRAM sheet is ALWAYS the catalyst of change. There will be at least a half dozen users of the file. So I need some way to always protect the synchronicity of the rows regardless of how they are inserted or deleted from the PROGRAM sheet

If you have a suggestion and it involves coding, please include the code in your reply. Thanks very much in advance to all who respond to this challenging problem