Macro to Combine Files then VLookup

I need a macro to that will combine 2 files, then add the Region from a 3rd file. The only way I know to do this is to do Vlookup and copy the formula down. I'm sure there is a way to do this using a loop that would make the macro more efficient. Details are below.

1) Copy data on ServiceArea1.xlsx (A2:Z to the end of data) onto ServiceArea2.xlsx to the next available row.
2) Add the Region Name onto ServiceArea2 (the combined file) in column O using the data from RegionList.xlsx (3rd file that is only used for pulling in the Region Name).
ServiceArea2.xlsx - Column N is Region ID, Column O - column to add Region Name from RegionList.xlsx
RegionList.xlsx - Column M is Region ID, Column N is Region Name


I appreciate your help.
Thanks.

I have attached the files:
ServiceArea1 - Copy this data onto ServiceArea2
ServiceArea2 - At the end, this file will have data from ServiceArea1 and ServiceArea2; along with column O completed with the Region Names
RegionList - This is file the Region Name is pulled from by Region ID
ServiceArea2_EndResult - File just showing what ServiceArea2 file would like after adding data from ServiceArea1 and Region Names


I appreciate your help.