How to link separate Excel files to auto-populate cells

Hi, I'm new to the forum and typically only use Excel for it's basic functions. I have multiple .csv files that will be analyzed in R. I would like to link a master dataset Excel file to the .csv files to auto-populate some cells to make data entry more manageable. The .csv files contain additional columns of data, but will share 4 columns in common with the master dataset. As an example:

I would like to be able to enter EITHER band name OR song title and have the other three columns auto-populate with the appropriate information. Here's what the master sheet would look like:

Band_Name	Song	Album	Release_Year
Elton John	Runaway Train	The One	1992
Metallica	Cure	Load	1996
The Cure	Friday I'm in Love	Wish	1992
Radiohead	Pyramid Song	Amnesiac	2001

Thanks for any help you can provide!