Dependencies - Unique ID/Primary Key

I have several spreadsheets that contain different info about equipment but they all have a unique identifier/primary key. I would like to import the spreadsheets, select the unique identifier in each one, and have Monday pull all of the info into one board - basically performing a power query. I understand that this can be done manually with mirror columns but the data is already there and this isn’t ideal. Even adding the ability to duplicate values from an existing column into a new mirror column would speed up this process.