Join the data of multiple sheets in an excel

Hi Team,

I have a excel file from the source where it has one lakh number of records. And that excel file has multiple sheets of data and is related with each other from a primary key.

I need to join the data of multiple sheets to have the related information of one entity.
Since the records count is more it is difficult to have join snap as it consumes time.

I have tried sorting and grouping and then fetching the info from other sheets. Still I need more feasible solution with less time consumption.

Mohammed Suhail