Filter data to different sheets

Hello,

I have a problem I hope I can get some help on.

I have a workbook with seven sheets. The first sheet is the main "database" with around 592 rows of data across nine columns (first row is locked title row). Under the first column is a code, 1-6. I need to filter all the data for each code into six different sheets in the same workbook. For example, everything with a "1" under "Code" would go to the second sheet, "2" to the third, and so forth. But, I also need that data spread across the other sheets to update with the main sheet. For example, if I change the name for someone with a "1" code, their name should change in the sheet for the 1s as well.

If I didn't explain that very well, I apologize and will try to clear up any questions as best I can.


Thank you.