Merge Multiple Excel Workbooks with Macro

[onmyway365]

Hi all,

I am stuck

and would really appreciate your help in this regard, and I thank you in advance!:

I need to write an app in excel that will merge multiple excel workbooks into one workbook (this could possibly be a macro / or vba UserForm containing the process that reads the workbooks and copies the data across).

Important: The process must not create or copy duplicate records. I will have a unique identifier field (GUID) for each record in each workbook.

I don't have anything to work off at this stage, so really appreciate your help!

Thanks!