Consolida Several Excel Spreadsheets Using Unique Identifier

I have 5 spreadsheets that contain a large ammount of information. The longest contains 630K records and each record haas a unique idetifier. The other 4 spreadsheets contain additional information about the records in the first spreadsheet, they vary in legnth. These other 4 spreadsheets contain the unique identifier that ties them to the larger dataset, but not every record is present, some records do not require the additional information that is stored in these 4 spreadsheets. I need this to be consolidated into 1 spreadsheet. Where each of the 630K records will be in one place with all of the information available.