Copy and duplicate cells onto other spreadsheets

Hi,

I just know the basics to excel, so hoping for a bit a help before I waid into the formulas.

Want to copy the information from one spreadsheet onto another spreadsheet.

It's for a reservations/bookings sheet. The excel workbook is attached that has three sheets in, that hopefully show you what I mean.

The arrivals sheet has every-ones details in. The idea would be the guests details would corrilate between the other two sheets in the wookbook, with the use of formula.

I've input some guests details to show you how it should work. Hope this makes some sense.

If there is a simpler way, or better way, I can always change some things around.

Really appreciate any help I can get on this, not sure where to start.

Thanks a lot for your time.