What I want to do is has the option to fill out the log sheet with either information from the call-in log or the PGL log. So what needs to happen is we have a permanent guest list here and also a list for call in list which is different daily. I want to be able to just use an ID number to have the information populate on the guest log sheet. From the 2 different data sheets.

The data sheets need to be separate as there are a lot of names to add to it and the other changes daily as I mentioned. I'm open to use any formula to achieve this as I've watched several videos and they all have a different way of doing things.