Automatically copy contents from one excel sheet to another

scenario.png

Hi, as sown in the image, I have an excel sheet which I set filter on name. (A, B, C) and save them as separate files like A.xls and so on. Data is updated by respective users in their respective excel files. My requirement is, how could I automatically copy content from all the files back to the parent excel file. Upon opening the parent excel file, it should fetch the currently available data from all the files. Could anyone guide me on achieving this?

Thanks in advance.

Bump. Could anyone reply to this thread?