Hi, I work for a travel agency and I have an excel workbook with 3 different sheets.

The first sheet is all the main information from customer names, reference numbers, accommodation, email...
The second sheet is excursion information from those customers (also with their reference numbers)
The third sheet is extra's from those customers (also with their reference numbers)

Screenshot 2022-10-12 at 12.42.51.png

Is there a way that I can link the second and third sheets with the customers in the first sheet? The names are the same, as well as the reference number in all three of the sheets. But I want all the information with the right name and number and all of the extra's/excursions in one big sheet to have an overview.