VBA or function to collect data from excel files and send it to another excel file.

I need VBA code or function to do this scenario:

(I have attached three files: File 1, File 2, and file)

- Macro should be put in sheet 1 of the attached File 1 and File 2. 

- Macro sends the information of sheet 1 in each File 1 and File 2 to another excel file (File) without deleting any information related. 

- Arrange the information as shown in sheet 1 of (File)

is it possible to do that? and How can do it?

Many thanks in advance