Need to return column header when a value is found in a table in different worksheets.

[ironmaiden666]

I work for a B2B tech company. I have a database of business contacts with their company names, phone numbers and other contact information (Sheet 1). I have separate files which has details about companies and what each is looking to purchase technology-wise. I want to merge these files into one file in such a way that I can see against my contacts, what technology solutions their companies are planning to buy. This will really help sales efforts.

The underlying logic I think I need to use is this: "If [Name of Company] is found anywhere in a table with multiple columns in Sheet 2/3/4, return the column header in sheet 1". I will demonstrate in a table below what I'm looking for. I need to fill in the italicized parts:

Sheet 1

Contact Name	Company	Phone	Email	Company Revenue (from sheet 2)	Agent Analytics (from Sheet 3)	Cloud Solutions (from Sheet 4)
Person 1	A			$10bn+	Immediately	6-12 months
Person 2	B			$10bn+	6-12 months	Immediately

<tbody>
</tbody>

Sheet 2 - Company Revenue

$10bn+	$5-10bn	$1-5bn	$500mn-1bn	<500mn
A	E	K	P	V
B	F	L	Q	W
C	G	M	R	X
D	H	N	S
	I	O	T
	J		U

<tbody>
</tbody>

Sheet 3 - Agent Analytics Solutions

Immediately	6-12 months	12-24 months
A	G	M
D	C	I
F	B	U
	X	S

<tbody>
</tbody>

Sheet 4 - Cloud Solutions

Immediately	6-12 months	12-24 months
B	Q	L
H	A	P
W	D	T
	X	F

<tbody>
</tbody>

Can someone please help me with this? I have tried so many options but I keep making mistakes