Sorting over multiple spreadsheets

[zerolife]

I'm looking for a big help on a challenging sorting problem.

- There are three sheets I'll name #1, #2, and #3.
- Sheet #2 has columns that are propagated from sheet #1 and columns where the data are entered manually.
- Sheet #3 are propagated from sheet #2 and sheet #3
- All three sheets have been formatted as a table (through the Format As Table feature) in order to make sorting easier. The column title in all three sheets are at row 4 while the data (body) are between rows 5 and 49. So row 5 in sheet #1 matches the same item as row 5 in sheets #2 and #3 etc.
- Additional rows may be added in the future. I already have a macro that will automatically add new rows in all three sheets and copy the appropriate formula.

Is there anyway to sort a column in Sheet 1 and have Sheet 2 and Sheet 3 sorted appropriately too? Column A is an ID (counting from 1) and is consistant throughout all three sheets. I guess the most logic way is that Excel reads the ID in Column A and automatically sorts the tables in the other two sheets to match Column A in Sheet #1.

Please let me know if anything sounds unclear and I'll be glad to clarify.

Thank you in advance for any help

Paul