I am attempting to combine information from one sheet into another and I do
not have a clue how to do this for almost a thousand contacts. Any
suggestions? Thanks in advance for any assistance.

Below is an example of what sheet 1 and sheet 2 look like:

Sheet 1

Co. Name Address City Zip
ABC 123 Oak Abe 91456


Sheet 2

Co Name ABC
Address 123 Oak
City Abe
Zip 91456