Linking data in different tabs

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.

You can use an INDEX/MATCH formula to bring data from the appropriate sheet. If you attach a (suitably anonymised) sample Excel workbook by following the guidelines in the yellow banner at the top of the screen, we will be able to advise further.

Hope this helps.

Pete