Formula/Function connecting from one sheet to another

[Chandler8]

Hey guys, I could use a formula for any time a specific persons name from the sheet (Guest_Info) in the (registered_Guest1-5) columns is mentioned it brings up their corresponding sponsor name from column (X) also in the (Guest_Info) sheet to cell G4 and down in the (Guest_list) sheet. Here is some pictures! If you have any questions lemme know. Thank you!

Rental Arrivals.xlsm
	F	G	H	I	J	K						Q						W	X
3	Registered_Guest1	Registered_Guest2	Registered_Guest3	Registered_Guest4	Registered_Guest5	A						B						C	Sponsor_Last_Name
4	Catherine Frye	Rick Jones																	Jordan
5	Greg Proctor	Trina Proctor	Mark Poovey	Sharon Poovey															Members
6	Neal Blinde	Jessica Blinde	Arden Blinde	Norah Blinde	Graham Blinde														Members
7	Stacie Menichella	Dan Menichella	Bryce Menichella	Brandon Artiqua	Lauren Artiqua														Members
8	Dave Powell	Meredith Powell	Porter Powell	Rivers Powell	Ella Powell														Turner
9	David Taylor	Elizabeth Taylor	Broughton Taylor	William Taylor															Members
10	Michael Patton	Amy Patton																	Members
11	Anne Warren	Ellie Waren	Timothy Warren	Claire Warren	Jeff Warren														McCavera
12	Patrick Walsh	Emily Walsh	Michael Walsh	Martha Walsh	Patrick Jr. Walsh														GGCC/Porter
13	Mark Frisch																		Members
14	Cam Findlay	Amy Findlay	David Findlay	Susan Findlay	Kathryn Beiser														Members
15	Hans Stig Moller	Nancy Stig Moller	Catherine Stig Moller	Rita Stig Moller	Jens Stig Moller														Dalrymple
16	Ginny Shaw	Ruthie Shaw	Finley Shaw	Robbie Shaw	Alan Shaw														NA
17	Chip Dotson	Mike Kavanagh	John Lady																Powell
18	John Simmons	Cathy Simons	Elliott Simmons	David Simmons	Mary Catherine Simmons														Members
19	Kelly Taylow	Matt Taylor	Hank Taylor	Maggie Taylor															Threlkeld
20	Cathy Blackwelder	Emery Blackwelder	Chip Blackwelder	Alli Wengert	Ben Wengert														Blackwelder
Guest_Info

Rental Arrivals.xlsm
	G
3	Sponsor Name
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Guest_List

 

[Chandler8]

Bump

 

[Chandler8]

Bump