Macro formula to combine 2 excel files into 1

Hello my name is Eric and I'm new here and I need some help and I would appreciate anyone's help. Here is my dilemma I have 3 different excel files report1, report2, and report3. Report1 one is from one location and report2 is from another location and report3 is blank. Now i wanna create a macro in report3 so it can add the results from report1 and report2 and bring it over to report3. Is this possible? I am not very good with macros and i would appreciate all the help.. Thanks