automatic data update in different sheets

[manseda]

Please see attached file. In sheet 1, data will be updated daily basis. From sheet 2 to sheet x, all new data have to be updated automatically according to the updated data in sheet 1. What do I need to do to have this?

[Haseeb Avarakkan]

Hello manseda,

Assume you need separate sheet for each personnel. You can use Filter to see & copy each person's details.

See the attached. On Sheet3 D1 change the name, then below you can see the data related to that personnel. This is doing same like as Filtering. If you need separate sheet for each personnel, copy the sheet, change the sheet name & change the name in D1.

Hope this helps.