EXCEL and macros, to reduce the 2 files into one

Good day,
Accept monthly reports from the two companies (in xls),
need a program or macro, to combine this information into a single file, in a specific order.
(uploading two files in one folder -