populate summary separated range for each name across files for same sheet name

[maghari]

but I guess the OP is not interested anymore

sorry for delaying !!
your code is excellent.
many thanks Jindon for your help.