MACRO Help: FIND and COPY Specific contact information from another sheet?

[jeffcoleky]

I'm trying to grab the data from the "Results" tab, which contains data in rows, and put it in Sheet1 in columns. The data will ALWAYS be in [Results] Column A, but the catch is that the row number that contains the data isn't always the same.Data goes from here:

	A	A	A
1	preferred contact method:	preferred contact method:	preferred contact method:
2
3	email	text	phone
4	phone
5	text	contact name:
6			contact name:
7	contact name:	Valentina
8			contact by phone:
9	Valentina	contact by phone:
10			☎​ 8885055050
11	contact by phone:	☎​ 8885055050
12			User's Email Address
13	☎​ 8885055050	User's Email Address
14			bob@smith.com
15	User's Email Address	Our other sites
16			Our other sites
17	bob@smith.com	site1
18		site2	site1
19	Our other sites	site3	site2
20			site3
21	site1
22	site2	Email to copy and paste:
23	site3		Email to copy and paste:
24		bob@smith.com
25
26	Email to copy and paste:
27
28	bob@smith.com
29
30	Example 1	Example 2	Example 3

<tbody>
</tbody>

Results

TO HERE:

Excel 2010
	A	B	C
1	Name	Preferred Contact Method(s)	Email Address
2	Bob Smith	email, phone, text	bob@smith.com
Sheet1

---------

I'd like to run a macro to pull the data from Results:A:A into the Currently selected Row on Sheet 1, (as it is above).

Some things are always true:
1) Phone number always has a "☎ " symbol in front of it and is always two rows below "contact by phone:"
2) Contact name is always two rows below the "Contact Name" text, IF it is present.
3) User's Email Address is always two rows below the "User's Email Address" text, IF it is present.
4) the order in which they are displayed doesn't change.
5) There will always only be one email, phone, or name associated with each record.

Here is a sample file

Is this enough info for someone to help me create such a macro? Any help or suggestions offered shall be MUCH appreciated.
​

 

[jeffcoleky]

Would it help facilitate an answer if I simplified the question?

Using a script, how do I copy and paste an email address from another sheet if I don't know which row it is on? (but do know which column)