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
preferred contact method:	preferred contact method:	preferred contact method:
email	text	phone
phone
text	contact name:
contact name:
contact name:	Valentina
contact by phone:
Valentina	contact by phone:
☎​ 8885055050
contact by phone:	☎​ 8885055050
User's Email Address
☎​ 8885055050	User's Email Address
bob@smith.com
User's Email Address	Our other sites
Our other sites
bob@smith.com	site1
site2	site1
Our other sites	site3	site2
site3
site1
site2	Email to copy and paste:
site3	Email to copy and paste:
bob@smith.com
Email to copy and paste:
bob@smith.com

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]
[TD="bgcolor: #FFFF00, align: center"]Example 1[/TD]
[TD="bgcolor: #FFFF00, align: center"]Example 2[/TD]
[TD="bgcolor: #FFFF00, align: center"]Example 3[/TD]

</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)