Pulling values from multiple saved workbooks in a folder into respective sheets

Hi all,

I'd really appreciate any help someone can provide with a problem I am facing. Pretty inexperienced with VBA but try my best!

I'm looking to essentially merge 3 input workbooks (each containing 1 sheet) into a master file that then uses this data to populate a number of fields and runs some validations. The latter part I have sussed (referencing the fields, headers and running validation), however currently it requires the user to copy and paste into each sheet in the master. I understand that there could be a way for the user to save the 3 files in a given folder and then specify the location in the master spreadsheet that can then pull the data respectively.

Is this possible?

Thanks in advance,
James