Automatically sorting data in other sheets

[Jacekdaniel]

Hi, I’m trying to play with excel formulas and find some useful functions myself. I’m starting recording some macros and make use of them.
Unfortunately I couldn’t sort it this time. I need some advice. I have about 12 of sheets in workbook with connected data and formulas. I have column “Name” in each sheet but I type data for this column only in the first one. In other sheets it is copied and locked. When I sort data in first sheet by column “Name” I want to have entire rows in other sheets moved together with the sorted “Name” data. If it is not clear enough I attached some sample spreadsheet to better understanding what I want to achieve.
Many thanks for any help.