Merging two files into one sheet

Hi all,

This is my first post here on the forum. Thank you in advance for any help.

long story short... I am looking to merge two .xls databases into one spreadsheet. I would like the process to be repeatable as well.

context: I am working with two separate therapeutic pipeline databases that allow me to export as xls files. They have some different column names and a lot of information. It would save my company a lot of time to be able to merge these two databases by matching important column data across sheets and removing the duplicates. I need to be able to do this over and over, any time I want to use these two databases to provide drug pipeline pulls.

I would love to ideas on best practices and any helpful discussion.

EDIT: The files are attached below in a reply.

Thank you again,
Creed