Create Excel or Access Database

I have 8 excel file templates that I need to merge the info together based on Reference #. I need to keep all of the titles shown in red for each column of all files and put them together into one file. Each file offers new columns of data based on the Reference #. The master file will have only 1 Reference # and show all of the data in the columns in all files that relates to that same reference # and display it in the same row. I have Excel and Access 2010. I need a process or database that allows me to export the results in an organized manner. I need to be able to do this with other files with the exact same template in the future. Its possible it might be best to create a database that collects all data relating to each Reference # and allows me to export it as such.